AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N1499SSkylane Pictures LLC · Los Angeles, CAN1499YHockenberry Randall L · Cape Coral, FLN149AFTitan Group Inc · Tucson, AZN149ARB-Cat Aviation LLC · Tulsa, OKN149GJAircraft Trustee Services Inc Trustee · Dover, DEN149JCCorrea Javier Rafael · Caguas, PRN149TBonilla Jose · Pembroke Pines, FLN14AUBazzo Richard J · Broadview Heights, OHN14AZD & L Aircraft Leasing LLC · Ormond Beach, FLN14BABurris & Macomber P L L C Trustee · Tucson, AZN14BLEagle Equity Inc · Valparaiso, INN14BMPeyton James L II · Granby, CON14CWThornwall Gregory C · Boonsboro, MDN14GLMc Flying Club Inc · Lewistown, PAN14HKTrolinger John D · Kerrville, TXN14JDC340-340 LLC · Pinckney, MIN14JMMckinstry Aviation LLC · Parker, CON14KMRiver City Aero Club Inc · Columbus, GAN14LVSmetana Louis V III · Blair, NEN14MDDaniel Development LLC · Durango, CON14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLN14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYN14NFStiles Terry D · King Salmon, AKN14NNAms Aviation LLC · South Bend, INN14PHHuman Lee · Mercer Island, WAN14PLByers Steven · San Diego, CAN14PNNefas Paul J · Sunland, CAN14RTSierra Ae LLC · Wilmington, DEN14SKHillsboro Aero Academy LLC · Hillsboro, ORN14SWTriple R Ministries Inc · Crestview, FLN14TXMcbride Robert W Jr · Mineola, TXN14UAMilam Equipment LLC · Trussville, ALN14VCG5 LLC · Gallup, NMN14WAWright Brandon C · Cave City, KYN14YYNorthwoods Air LLC · Orono, MEN150Beam David · Sabina, OHN15000Central District Aviation LLC · Seattle, WAN1500G5 Lg LLC · Rome, GAN1500QShoaff Mark · Lehigh, FLN1500TAguilar Honorio · Anna, TXN1501MMeszler Christopher P · Spring Branch, TXN1501VChinook Flying Club LLC · Chinook, MTN1501YStreeter Christopher D · Vinita, OKN1503UAmerican Jet Center Inc · Chino, CAN1504VCulman William A · Scotts Valley, CAN1505QN1505q LLC · Brunswick, GAN15060Palm View Aircraft Corp · Santa Rosa Beach, FLN1506MBonn Steven · Hummelstown, PAN1506QDonald A D · Plano, TXN1506VDeshon Loren · Friday Harbor, WA
Back to AD 97-01-13