AD 95-26-16 R1
Registered aircraft · 1,406
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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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.
N3830HFox Joseph Craig · Claremont, NCN3832HSwint Eric · Ardmore, OKN3840HJzhs LLC · Charlottesville, VAN3844HJlvav8r LLC · Murphy, NCN3846HLake Willis Investments LLC · Orlando, FLN3851HPop City Air LLC · Greenville, NCN3860HPatriot Aviation LLC · Farwell, MIN3863HFairley Maurice A · Emerald Isle, NCN3875HSchulz David D · Scottsdale, AZN3883HMovshin Mikhail · Aiken, SCN3886HBerkebile Matthew · Midland, TXN3891HJohn R Loar · Kemp, TXN3898HTrue Course Holdings LLC · Ruston, LAN389DCJehn Frank · Jackson, NJN3908HVu Ai T · Aiea, HIN3916HCopeland Greg · Lake Dallas, TXN3917H802 Aviation LLC · Colchester, VTN3925HSale Reported · Corona, CASale reported, pending cancellationN3933HRoberts William J Jr · Apex, NCN3941HHamilton Todd J · May, TXN3963HDiamant Zafrir · Las Vegas, NVN3970HWheeler Martin C · Eden Prairie, MNN398GLembo Daniel A · North Syracuse, NYN3990HLasar Inc · Prineville, ORN3YFKaelin Oscar J · Newbury, NHN4013HAgbunag Rodolfo V · San Marcos, CAN4014HHoof Jonathan Craig · Williamsburg, VAN4019HAnton William J · Lubbock, TXN401RKRegistered aircraftN4048HL Heureux Brett J · Eustis, FLN4049HStrand Jeffrey F · Scottsburg, INN4052HFair Bryan R · Rhome, TXN4054HMoon Dawg LLC · Tijeras, NMN4055HClark Todd A · Kalispell, MTN4056HKirchner Matthew R · Dalton, MAN4058HEllis Fife Baker · Cypress, TXN4064HRac Enorian S · Destin, FLN4065HGreen Brian Michael · Chapel Hill, NCN4067HElliott Norman · Stillwater, OKN4071HDashiell Jeffrey A · Odessa, TXN4074HScheinpflug Larry R · Dunwoody, GAN407LALangewisch Gary R · Pasadena, CAN4083HJones Jeffrey W · San Antonio, TXN4084HKremer Gabriel J · Fort Madison, IAN40ALHelm Mark · Palm Harbor, FLN40BKGray Padraic W · Cypress, TXN40FGAllen Stephen G J · Peshastin, WAN40MJOn Top Aero LLC · Avon, CTN40NRMooney V LLC · Dunbarton, NHN40SVBarr Michael B · Houston, TX
Back to AD 95-26-16 R1