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.
N364MGCw Aviation LLC · Washta, IAN364MKNorth Star Aviation Inc · Mankato, MNN364MSSkyhawk Aviation LLC · Omaha, NEN364MWUpwind Approach LLC · Lisle, ILN364SCTfs Inc · Chelsea, ALN364SLRegistration Pending · Carmel, CARegistration pendingN364SSLampert David M · Atherton, CAN364TJohnsons Ag-Air Inc · Tyler, MNN364TWVo Thien T · Amarillo, TXN364VKPetts Adam · Waukee, IAN364WMMoore Bruce W · Aledo, TXN364WPPorter Flying Service · Durham, CAN364ZAlpha Tango Aircraft LLC · Wilmington, DEN3650AMcclain Aviation LLC · Newark, DEN3650CTotty Michael N · Gainesville, MON3650RScd Medical LLC · Alexandria, LAN36511Worley Regenna G · Ellijay, GAN3651CHately William · Anchorage, AKN3651UDeibel Adam · Flagstaff, AZN3651WTraxler Christopher V · Russia, OHN3651ZCrabtree Glenn E · Guthrie, OKN3652QNolen David S · Wimberley, TXN3652RShales Rene J · Hampshire, ILN3652WValiair Limited Co Trustee · Casper, WYN3652YMokhtari Rasoul · Nashville, TNN3653AKlemenhagen David · Wasilla, AKN3653CDomingquez Clara · Anchorage, AKN3653NBurch Herbert K · Milan, OHN3653PWright Michael · Hurricane, UTN3653QFlying Naked Muskteers LLC · Palm City, FLN3653RSingh Harsimran · Las Vegas, NVN3653UMedeiros Germano Manuel · Caruthers, CAN3653ZMandibles Edward Jr · Lompoc, CAN36541Plains Aviation · Mitchell, SDN36546Lighthouse Drones LLC · New Smyrna Beach, FLN3654CRose Hugh S · Fairbanks, AKN3654KBeaber Michael J · Fremont, OHN3654RSierra Delta 1 LLC · Dover, DEN36555Smith Jeffrey D · Murrells Inlet, SCN3655CViavant Toby S · Ester, AKN3655NPeterson Jesse D · Wasilla, AKN3655UBoggs Dennis E · Buffalo, WYN36563Ware Richard A · Versailles, OHN36565Maxwell James B · Lewiston, IDN36567Kempton Larry G Jr · Grand Junction, CON3656PKennedy Lukas · Anchorage, AKN3656UMccarty Troy Allen · New Plymouth, IDN3656WNuvision Heaqlth Center · Macomb, MIN36574California In Nice Inc · San Jose, CAN36575Brill Charles F · Spring, TX
Back to AD 2007-04-19 R1