AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N56501Hair Heather D Trustee · Bonner, MTN56506Nassour Aviation Inc · Ellisville, MSN5650QOrtland Richard James · Franklin, MIN5650SOliver Jonathan · Maryville, TNN5650USkyways Group LLC · Greensboro, NCN5651BRoland David K · Lockhart, TXN5651HCramer Nicholas R · Lexington, OHN5651QKingdom Air LLC · Diamondhead, MSN5652Leary Brian J · Fredricksburg, PAN56521Hawkes Tyler · Rexburg, IDN56524Registration Pending · West Palm Beach, FLRegistration pendingN56525Sadi Susan Salimi · Arlington, TXN56528Delzer James K · Sanger, TXN56529Jilek Peter A · River Falls, WIN5652ECgumps LLC · Antioch, TNN5652LSkelton Thomas Nichols Jr · Jackson, MSN5652WDamazo Kimber P · Portland, ORN5652ZClifford Karl N · Lubbock, TXN56536Hurlbut Gary A · Seattle, WAN5653LUlpiano Amy · Carolina, PRN5653PBeasley 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, OKN5655HRansdell Elise A · Springfield, ILN5655QJamil Mohammad Mahbub · Stockton, CAN5655RKavalieros James A · Bridgewater, NJN5655ZTroth Gary D · Mound City, KSN5656EN2893e LLC · Reno, NVN5656HCaldwell Joel · Galveston, TXN5656PTaylor National Transportation LLC · Palatine, ILN5656WBennett Steven D · Durham, NCN5656YD & D Airpark LLC · Anchorage, AKN5657Woods Donald E · Great Falls, MTN56573Knuth Matthew · Waupaca, WIN56578Somerset Air Service Inc · Bedminster, NJ
Back to AD 90-04-06 R1