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.
N56526Registered aircraftN56528Delzer James K · Sanger, TXN56529Jilek Peter A · River Falls, WIN5652CRegistered aircraftN5652ECgumps LLC · Antioch, TNN5652HKerby Ryan S · Talkeetna, AKN5652LSkelton Thomas Nichols Jr · Jackson, MSN5652NMaule Airways Inc Trustee · Wilmington, DEN5652ULions Flyers Inc · Enterprise, ORN5652WDamazo Kimber P · Portland, ORN56536Hurlbut Gary A · Seattle, WAN56539Six 27 Properties LLC · Flint, TXN5653BKey Jon · Seminole, TXFirst renewal noticeN5653PBeasley Charles R · Lumberton, NCN5653RSchoenau Michael · Tulare, CAN5653UMcclelland Robert C · La Veta, CON5653WCrump William J · Williamstown, NJFirst renewal noticeN56545Sauder Richard J · Evergreen, CON56547Schroeder Gordon D · New Braunfels, TXN5654BStol-Air LLC · Salem, ORFirst renewal noticeN5654DMiller Arlyn E · Boise, IDN5654PLiebrecht Dennis L DBA · Ocala, FLN5654SWilcox Ryan · Brookland, ARN5654URoss Michael M Trustee · Anchorage, AKN5654VHodges Tandi R · The Woodlands, TXN5654WHaymes Will · Knoxville, TNN5655Phillips Mark E · Williamsville, ILN56550Holmes Peter L · Erieville, NYN56557Mannering Robert D · Warrensburg, MON56558Onlyfly LLC · Deltona, FLN56559Waggoner Gregory · Woodward, OKN5655CRegistration Pending · Westford, MARegistration pendingN5655JSale Reported · New Underwood, SDSale reported, pending cancellationN5655NWiley Aviation LLC · Saint Augustine, FLN5655PRegistration Pending · Parkland, FLRegistration pendingN5655QJamil Mohammad Mahbub · Stockton, CAN5655RKavalieros James A · Bridgewater, NJN5656BBryant David L · Glendale, ORN5656EN2893e LLC · Reno, NVN5656KTompkins Wyatt M · Pearland, TXN5656PTaylor National Transportation LLC · Palatine, ILN5656SAnderson Nathan A · Soldotna, AKN5656WBennett Steven D · Durham, NCN5656YD & D Airpark LLC · Anchorage, AKN56573Knuth Matthew · Waupaca, WIN56578Somerset Air Service Inc · Bedminster, NJN5657ADaily John F · Chugiak, AKN5657KWatson Robin G · Eastsound, WAN5657QRegistration Pending · Phoenix, AZRegistration pendingN5657RFord Darryl · Caldwell, ID
Back to AD 2007-04-19 R1