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.
N2177FSchofield William R · Fort Mill, SCN2177JPlane Skies Aviation · Cedar, MNN2177QKovarik Lucas M · Ord, NEN2177TRegistration Pending · Pine Mountain, GARegistration pending, pending cancellationN2177ZRegistration Pending · Fayetteville, NCRegistration pendingN2178CHowey Paul W · Stevensville, MDN2178SAbbey Alyssa · Novato, CAN2178TOrban John J · Dewitt, MIN2178WCarrillo Salvador Arias · Lompoc, CAN2178YN2178y LLC · Cumming, GAN2178ZMaloskey Scott M · Marion, IAN21796Seegmiller Geoffrey · Houston, TXN2179MKairez Carolyn E · Punta Gorda, FLN2179TKroeger William R · Plattsmouth, NEN2179UFlorea Byron · Carencro, LAN2179ZHill Robert · Anaheim, CAN217BWAuer William E · East Liverpool, OHN217DKHawaii Pacific Aviation Inc · Kailua Kona, HIN217DLValiair Lc Trustee · Casper, WYN217EPEpic Aviation Inc · New Smyrna Beach, FLFirst renewal noticeN217LFSnyder Aero LLC · Joshua, TXN217LSCole Spur Aviation LLC · Gould, ARN217PFBixenman Kenneth J · Colby, KSN217TSLaukatel Air Inc Trustee · Wilmington, DEN217TXLong Jeffrey E · Dothan, ALN21802Owen Michael C · Seaside, CAN21803Morgan Edward · Gaithersburg, MDN2180FGentle Breezes LLC · Johnson City, TNN2180KRoad Runner Flying Club Inc · Radcliffe, IAN2180RRoan Paul J · Clive, IAN2180TDe Bella Richard M Sr · Blackwood, NJN2180WGerges Amir · Arlington, TXN2180YAstro Aviation LLC · Cross Plains, TNN2180ZM&M Aero LLC · Wilmington, DEN2181AL&C Ventures LLC · Clovis, NMN2181NState Of Oregon · Salem, ORN2181TAdk Flying Club Inc · Ballston Spa, NYN21825Shepherd David K J · Bakersfield, CAN2182BFlying 20 Club Inc · Springfield, ILN2182CSkyhunter LLC · Yonkers, NYN2182FKleen Sheen IV LLC · Bowling Green, KYN2182KDura Built LLC · Greensburg, KYN2182QCassett Terry D · Mankato, MNN2182SCimprich Michael J · Kirkland, WAN2182VJavorsek Daniel II · Harriman, TNN21836C & S Development Services LLC · Weatherford, TXN2183CVaughn Michael A Jr · Oxford, MIN2183DLyons Terry L · Springfield, ILN2183JMichael Nehring Inc · Mohall, NDN2183KMaven Aviation LLC · Dillon, MT
Back to AD 2006-10-21