AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-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:2006-10-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:2006-10-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:2006-10-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.
N20KPHulsey Ryan A · Cleveland, GAN20LEQuality Leasing Inc · Niceville, FLN20LGYerena Mario Cesar Gutierrez · Bethel Island, CAN20LKHobert Robert W Trustee · Penn Valley, CAN20LLFlying 20 Club Inc · Springfield, ILN20LTSeagull Services LLC · San Rafael, CAN20LUCamas Wings LLC · Camas, WAN20LXLockheed Martin Corporation · Palmdale, CAN20MNRichardson William L · Houston, TXN20MRRegistered aircraftN20MVElizabeth City State University · Elizabeth City, NCN20NASchneider Adam R · Hutchinson, KSN20NBStauffer Michael S · Wichita Falls, TXN20NCJohnson Professional Aviation LLC · League City, TXN20NDSheff Donald · Redwood City, CAN20PAntique Preservation Association Of Greenfield · Greenfield, IAN20PSSolberg Kevin L · West Fargo, NDN20PVPiper Aircraft Inc · Vero Beach, FLN20QCHenderson Stephen L · Carthage, NCN20RDickerson Stephen R · Frisco, TXN20RDSpurlin James Raleigh · Tomball, TXN20RTTyson Richard E · Barton, FLN20RVSadek Khaled · East Brunswick, NJN20RXHayashi Linda · Playa Vista, CAN20SALc Air Leasing LLC · Treasure Island, FLN20SNHealy Edward · Fort Atkinson, WIN20SSBurton Scott C · Henderson, NVN20SUOhio State University · Columbus, OHN20SVM&A Aircraft LLC · Rancho Cucamonga, CAN20TACopperstone Fc LLC · Lancaster, PAN20TBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN20TKVanguard Executive LLC · Elfers, FLN20TLN20tl LLC · Incline Village, NVN20TUClark Steven · Dade City, FLN20VCDanny J Daigle LLC · Greenville, MEN20VMHaney Kieron J · Irrigon, ORN20VTRegistered aircraftN20WSeawind Mjw LLC · Wappingers Falls, NYN20XTDon Maxwell Aviation Service Inc · Longview, TXN20YHuckabee Jim · Amarillo, TXN20YBBurdick Rich · Montrose, COFirst renewal noticeN2100AAniakudo Obiesili · Northville, MIN2100DL A M Capital Management LLC · Sheridan, WYN2100SBietsch Aviation LLC · Dumfries, VAN21018Vega Aircraft LLC · Arcadia, OKN21019Svetfur Aviation LLC · Camden, SCN2101FVaughan Bradley C · Truckee, CAN2101GCarter James E · Thornville, OHN2101TTraylor John M · Helena, ALN2101UVansurdam John R · Seneca, SC
Back to AD 2006-10-21