AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N283CBSky High Investments LLC · Greenwood, INN283DFrohbieter Alan · Superior, CON283GWend Roger W · Charlotte, MIN283HGCompas Rose 3 LLC · Corinth, TXN283HPClarke John D Jr · Port Orange, FLN283LPPecue Michael T · Mount Dora, FLN283MAAtaraxia Aircraft Holdings LLC · Greenville, SCN283MBOakwood Air LLC · Sioux Falls, SDN283MEN283me LLC · Manassas, VAN283PWings Flight Group LLC · Las Vegas, NVN283PEDolphin Leasing LLC · Daytona Beach, FLN283RMahkorn Shawn · Murrieta, CAN283RDBengtson Douglas Richard · Woodinville, WAN283SWake Turbulence Corp · Wilmington, DEN283TBNance Joseph W · Fort Collins, CON283TMSpady Jeffrey · Springfield, ORN283TYSoleil Helicopters LLC · Tucson, AZN283WMMaedgen Gary W · Voss, TXN283ZAlpha Tango Aircraft LLC · Wilmington, DEN284Grissom Timothy J · Columbia City, INN2840ALipovetsky Sergy J · Sacramento, CAN2840FMendive Richard J · Priest River, IDN2840GL'Avion LLC · Napoleonville, LAN2840MHamby Scott D · Custer, SDN2840PBourne Steven M · Brooksville, FLN2840RMorris Lorraine · Poplar Grove, ILN2840TDuval Daniel · Hohenwald, TNN2840YMcdonald Kelly · Amity, ORN28414Willer Aaron · Humboldt, TNN28417Gassaway Clay C · Whites Creek, TNN2841FDrago Gene Kirk · Bainbridge, GAN2841MHaller Robert W · Austin, TXN2841QWight John I · Anchorage, AKN2841RMoses Aviation Services LLC · Uvalde, TXN2841VSouth Jersey Aero Club Inc · Haddonfield, NJN2841XBerry Bradley A · Titusville, FLN2841YShimak Joseph O · Toms River, NJN2841ZVan Ryn William C · Hermiston, ORN28421Cae Aviation Academy Phoenix LLC · Mesa, AZN28423Brown Robert · Homestead, FLN2842DTwo Tangos Aviation LLC · Covington, LAN2842ELyon Aviation Inc · Pittsfield, MAN2842FKuhns Robert A Trustee · Geneseo, ILN2842PEaster Brett D · Enumclaw, WAN2842QLaning Roland · Monument, CON2842WHeisey Ronald B · Friendswood, TXN2842XWatkins Andrew A · Newark, TXFirst renewal noticeN2842YRocky Road Aviation LLC · Ruskin, FLN28431Ferguson James H · Huntington Beach, CAN28433Brandt Paul E · Casper, WY
Back to AD 2007-04-19 R1