AD 94-05-05 R1
Registered aircraft · 26,230
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N8508JJanssen Willis W · Ault, CON8508NHenderson Ramsey H · Pittsboro, NCN8508UEspinosa Isaac · Kissimmee, FLN85091Brutlag Paul D · Wendell, MNN8509BLafleur Joel A · Garden Valley, IDN8509GVictory Family Church Of Decatur Tx Inc · Decatur, TXN850DRMooers Michael T · Haggerstown, MDN850YDudley Benjamin H · Wasilla, AKN8510UTds Property Holdings LLC · Gilmer, TXN8511ERichter Von E · Climax, GAN8512AKiper Ted B · Crawfordville, FLN85130Mcdowell Charles T · Pittsgrove, NJN8513BFisher Steven B · Kuna, IDN8513ESessions Jaron B · Hemphill, TXN8513JHurd Billy R · North Pole, AKN8514UDyck Johan · Key Largo, FLN8514XPeck Eldon G · Grace, IDN8516BEdson David V · Ionia, IAN85173Ellis Jayson A · Benson, NCN85179Philpott Stuart L · Taylorsville, KYN8517UNortheast Cubs LLC · Wilmington, DEN85186Foley Ward · Westminster, CAN8518ELenbom Mark A · Cameron, WIN8518GDouble Rr Holdings LLC · Dallas, TXN8518QWilson Richard J · Naknek, AKN8518XHepner Karl E Jr · Clifton, VAN8519BNauerth John Henry III · Lakefield, MNN8519EBumblebee Aviation LLC · Dayton, OHN8519GSullivan Aviation Maintenance LLC · Fayetteville, NCN8519KMortenson Dennis L · Spanaway, WAN8520BCook Mike R · Rye, CON8520XJohn Robert W Jr · Andrews, TXN8521BHiebert Isaac G · Hachita, NMN8522JValley Jacob A · Brewer, MEN8522UHebbronville Machine Shop Llp · Hebbronville, TXN8523GStephany Peter T · Umatilla, FLN8523UEllis Clifford E · Emmitsburg, MDFirst renewal noticeN85243Tieman Richard L · Waynesboro, PAN85248Rishovd Thomas A II · Elk River, MNN8524BBecker Robert A · Santa Rosa, CAN8524ULewis Steven · Anchorage, AKN8524XPedroza Everett W · Tehachapi, CAN85257Musolf Jr William R · Spencer, OHN85259Jeffryes Richard B · Creswell, ORN8525ECal-Aerofab Flight Academy Inc · Chino, CAN8525JBicknell Hilary E · Warwick, RIN8525XBradford John R · Sheridan, ARN8526BMallory John C · Fairbanks, AKN8526GLong Sean · Germantown, TNN8527BWeber Randy J · Homer, AK
Back to AD 94-05-05 R1