AD 2021-24-21
Registered aircraft · 898
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-24-21') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N493QSRegistered aircraftN494BAM G Air Transport LLC · Newport, NCN494QSRegistered aircraftN495JHPhenom Holdings 495 LLC · Wilmington, DEN495QSRegistered aircraftN496QSBj'S Wholesale Club Inc · Oklahoma City, OKN497QSRegistered aircraftN498QSRegistered aircraftN499DTJedco Properties LLC · Nantucket, MAN499QS3ten Construction LLC · Oklahoma City, OKN4BRandolph Aviation LLC · Naples, FLN4CDEmbraer Executive Aircraft Inc · Melbourne, FLN4LMLm Aviation Advisors LLC · Missoula, MTN4MT4mt LLC · Naples, FLN4RSRcs Leasing LLC · Wentzville, MON500CJIsla Lab Caribbean LLC · Guaynabo, PRN500DAWtj Capital Holdings II LLC · Vero Beach, FLN500ECN500ec LLC · Columbus, MTN500RBOkvs LLC · Lake Sherwood, CAN500TPEmbraer Executive Aircraft Inc · Melbourne, FLN502DVBedrock Base LLC · Brecksville, OHN502TXState Of Texas · Austin, TXN503ERTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN503TXState Of Texas · Austin, TXN504TXState Of Texas · Austin, TXN504WPWjp Logistics LLC · Newark, DEN505FFJones Co · Waycross, GAN505GPPat Enterprises LLC · Santa Rosa Beach, FLN505LFRegistered aircraftN506BCrescent Solutions Group LLC · Park City, UTN506PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN509DDAir Services II LLC · Spokane, WAN511BCBc010101 LLC · Sioux Falls, SDN511KSEcho Matrix LLC · Bentonville, ARN511WKRegistered aircraftN514AFOtu Aerospace LLC · Horseshoe Bay, TXN515ESEmbraer Executive Aircraft Inc · Melbourne, FLN516NNicholas Services LLC · Oxford, MSN517TXTransmedics Inc · Belgrade, MTN521NTaylor Air LLC · Oxford, MSN521PEProaviation LLC · Sedalia, MON522EPRegistered aircraftN5237RGlasstrans LLC · East Moline, ILN523DMD Fla Aviation LLC · Bowling Green, KYN524NCActono LLC · Las Vegas, NVN525MNPierpont King LLC · Tulsa, OKN528TMB O E Bancshares Inc · Lawton, OKN529NNicholas Services LLC · Oxford, MSN535BCWac Charter Inc · Aurora, ORN535GBBank Of Utah Trustee · Salt Lake City, UT
Back to AD 2021-24-21