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.
N13YNWilliams Eric Lofton · Missouri City, TXN13ZERedge Akro LLC · Hampshire, ILN13ZF13zf LLC · Bend, ORN14004Grusenmeyer-Scott Aviation LLC · Orlando, FLN14005Delaware Aircraft Trust LLC Trustee · New Castle, DEN14007Kga Aviation LLC · Alfred, MEN14008Suburban Air Corp · Castro Valley, CAN14009Livingston Aviation Inc · Waterloo, IAN1400HAmeriflyers Of Texas Inc · Addison, TXN1400PJohnson Melanie Trustee · Saint James, MNFirst renewal noticeN14012Rock Valley College · Rockford, ILN14028Stoks Derek R · Canby, MNN1402XRegistration Pending · Oakwood, OHRegistration pendingN14036Booth Donald V · Denison, TXN14038Eagle Aviation And Logistics LLC · Cheyenne, WYN1403PPresby Aire LLC · Berlin, NHN1403ZMid America Sprayers Inc · Ulysses, KSN14040Island Aviation Inc Trustee · Wilmington, DEN14049Liberty Leasing II LLC · Melbourne, FLN1404CAeroscalper LLC · Goshen, INN1404PGreen Rose LLC · Swartz Creek, MIN1404YDavidson Bill · Lewisville, TXN14051Sams Way · Eagle Mountain, UTN1406CMcaninch Danny Ray · Pleasant Hill, CAN1406TCitabria Inc · Auburn, CAN14078Tundra Aviation Inc · Casselton, NDN1407DFlight Training Aircraft LLC · Wilmington, DEN1407JInternational Air Services Inc Trustee · Carson City, NVN1407TAndrews University · Berrien Springs, MIN1407WYoder Sylvan R · Camilla, GAN1407XRavotti Air LLC · Leechburg, PAN14089Szymanski Tadeusz · Fort Myers, FLN1408BIasco Flight Training Inc · Redding, CAN1408CHaworth Michael R · Riverside, CAN1408JRossi Scott J · Hallsville, TXN1409XHolmberg Shane A · Fairbanks, AKN140CACivil Air Patrol · Maxwell Afb, ALN140DCCheely Matthew G · Hillsdale, MIN140DHVeve Rafael A · Indn Hbr Bch, FLN140FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN140JAWhitney Lydia Mae · North Charleston, SCN140JGBarros Vincent · Kissimmee, FLN140RADenome Vincent G · Tampa, FLN140RDAlpha Whiskey 3 LLC · Brandon, MSN140RMMckenzie Michael C · Ventura, CAN140SMGarrett Mike · Okla City, OKN140SUOhio State University · Columbus, OHN140TAGuggenair LLC · Carbondale, CON140UDAb Prop Plane II LLC · Metairie, LAN140WMBlue Wings LLC · Rossville, TN
Back to AD 2006-10-21