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.
N5371FCummings Todd Bentley · Westfield, NCN5371KExecutive Aviation LLC · Peoria, AZN5371QTimber Creek Flyers Lc · Albion, IAN5371XMarks Max · Cape Elizabeth, MEN53720Christiansen Aviation LLC · Wilmington, DEN53723Garthus Nels · Grafton, WIN53724Hackamore Equipment LLC · Prairie City, SDN53725Registration Pending · Honolulu, HIRegistration pendingN53726Bower Jessica L · Oshkosh, WIN53728Stinecipher Wilson C · Wasilla, AKN5372CFlc Aviation LLC · Dyersburg, TNN5372DHanks Don N · Eagle River, AKN5372EThief River Aviation Inc · Thief River Falls, MNN5372SFlying Solo LLC · Omro, WIN5372VCooper'S Hawk Aviation LLC · Rochester, MIN53730Vance Jason · Lufkin, TXN53735Vermont Flight Academy · South Burlington, VTN53737Diloreto Gregory T · Jupiter, FLN53738G&G Equipment LLC · Wasilla, AKN5373EMoyer Thomas L · Fayetteville, GAN5373LDavies Patrick · Chula, GAN5373THorizon Aviation LLC · Brooks, GAN5373YBush Dan S · Wasilla, AKN53742Mh Aviation Inc · Lancaster, CAN53744Tango Echo Aero LLC · Holly Lake Ranch, TXN53746Apollo 18 LLC · Tipp City, OHN53747Tenkey Investments LLC · Tulsa, OKN5374DMoreau Clair L Jr · South Portland, MEN5374JMiles Brian R · Lake Jackson, TXN5374KApex Aircraft Leasing LLC · Anchorage, AKN5374LLund Chris J · Williston, NDFirst renewal noticeN5374PDeflorin David J · Harris, MNN5374TWeaver Stephen E · Enon, OHN53752Vectors West LLC · Coeur D Alene, IDN53753Erickson David R · West Point, UTN53754B U International Inc · Pierce, TXN53758Trailing Edge Aviation LLC · Lancaster, PAN53759Pacific Lease · Elk Grove, CAN5375DRamstad Trygg J · Anchorage, AKN5375JDaviss Joseph A · Sylacauga, ALN5375LDerose Kevin L · Janesville, CAN5375RArctic Flying Club · Fairbanks, AKN5375WOverly Christopher D · Williamsport, OHN53763Anderas Per R · Green Bay, WIN5376HPires Fernando L · Hilmar, CAN5376JTss Aviation LLC · Conyers, GAN5376NCowgill John David · Studio City, CAN5376PDuffield Michael · Sorrento, FLN5376WJenkins Walter J · Mayfield, UTN53772Quale Scott M · New Town, ND
Back to AD 2007-04-19 R1