AD 2000-23-21
Registered aircraft · 47,138
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:2000-23-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:2000-23-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:2000-23-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:2000-23-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.
N262VFBaker Geoffrey D · Philomath, ORN262WPage Jeffrey Vernon · Washington, PAN262WDWyoming Development LLC · Cheyenne, WYN262WEN262we LLC · Akron, OHN262WHJett Aviation LLC · Orangeburg, SCN2630GMarvil Sean · El Prado, NMN2630QParrington Robert · Rifle, CON2630RBurdine Kenneth L · Newland, NCN2630SDuquette Stephen R · Fenton, MIN2630XBbjc Adventures LLC · Jackson, WIN2631FShepherd Thomas A · Montgomery, NYFirst renewal noticeN2631GMac Neil David M · Clarkston, WAN2631QManning Brian A · Malvern, IAN2631SAsplundh Eric P · Bryn Athyn, PAN2632BHeubeck Associates Inc · New York, NYN2632FOn Final Holdings LLC · West Olive, MIN2632GHuey James M · Fulton, MOFirst renewal noticeN2632PBargabos Richard O · Peterboro, NYN2632SAvialogia Inc · Wilmington, DEN2633FYork Greg · Blanco, TXN2633RDevries Mark R · Eagle River, AKN2633SAir Apparent LLC · Santa Rosa, CAFirst renewal noticeN2634FCockerham Milton D · Gooding, IDN2635BGrimes Jeremy M · Wasilla, AKN2635GStockton Finance Inc · New Braunfels, TXN2635KVerdi Stephen · Newtown, PAN2635RJong Hoon Cho · Rch Palos Vrd, CAN2636FCernilia James J · Newport Beach, CAN2636GHousken George E · Gardnerville, NVFirst renewal noticeN26370Gv Air Inc · Medford, ORN2637DMcanulla Robert · Trabuco Canyon, CAN2637FMccrum James M · Seattle, WAN2637GSalisbury Jonathan T · Seabeck, WAN2638CPickett Joseph C · El Paso, TXN2638GEvans Steven H · Hattiesburg, MSN2638XSoftware 2000 Inc · Arroyo Grande, CAN2638ZHowlett Corey W · Wasilla, AKN2639FHendershott Kevin J · Vacaville, CAN2639GHusted Dean T · Hicksville, OHN263AAWilkey Michael B · Kingston, GAN263CDHayon Ilan · Oakland Park, FLN263DBZulu Murphy LLC · Oklahoma City, OKN263DDRegistered aircraftN263DWWarren David T · Mobile, ALN263EAJdcwac LLC · Blair, NEN263HBTakahashi Hector · Livingston, NJN263MMDkh Equipment LLC · Andover, MNN263RBCarmarg3 LLC · Hilton Head Island, SCN263SAColumbia Asset Trust Corp Trustee · Wichita, KSN263SRMacair Aviation LLC · Xenia, OH
Back to AD 2000-23-21