AD 97-01-12
Registered aircraft · 489
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-12')
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-12')
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-12') 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-12') 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.
N168WSPantechnicon Aviation Ltd · Minden, NVN170RLN170rl LLC · California, MDN175SAGeneral Atomics · San Diego, CAN175SWDenaina Air Taxi LLC · Anchorage, AKN176MRegent Trust Corp Trustee · Wichita, KSN177CNRca Aviation 2 LLC · Tempe, AZN17812Best Aircraft Deals LLC · Salt Lake City, UTN17VAOptimal Aviation Services LLC · Visalia, CAN17VVPro Field Services Inc · Hallettsville, TXN181RK330 Am Holding Corp · Miami, FLN183AKRegistered aircraftN184SWCbg LLC · Wilsonville, ORN187MRJcs Air LLC · Auburn, ALN1888TGood Aviation LLC · Oshkosh, WIN188ACTanglefoot Wing And Wheel Co · Coolin, IDN188ALAlm Holdings Delaware 3 LLC · Wilmington, DEN189ALAlm Holdings Delaware 4 LLC · Wilmington, DEN189APRegistered aircraftN189WAAmeriflight LLC · Dallas, TXN18KATreetoppers II LLC · Newark, DEN191WAAmeriflight LLC · Dallas, TXN1924TUas Transervices Inc · Boca Raton, FLN1926A1926a LLC · Auburn, ALN192WAAmeriflight LLC · Dallas, TXN197WAAmeriflight LLC · Dallas, TXN199CZN199cz LLC · Milwaukee, WIN1HXCentralav LLC · Lake Worth, FLN1MNDukes Garage LLC · Boulder, CON200BTMid-South Regional Aviation LLC · Tunica, MSN200GWNogottie Landing Co LLC · Amarillo, TXN200JLCrest Trading Company · Bakersfield, CAN200PZBeech Transportation Inc · Eden Prairie, MNN200SNAdvantage Jet Holdings LLC · Chino Hills, CAN200VAVargus Group Inc · Providence, RIN200WXMorales J Mark Trustee · Corpus Christi, TXN202WSCorsair Turbines LLC · Georgetown, TXN203TASouthwest Aviation Specialties LLC · Tulsa, OKN204TPW & W Innovative Enterprises LLC · Douglas, GAN206PRidgeaire Inc · Jacksonville, TXN208BCOutside In Aviation LLC · Fort Madison, IAN208FDelaware Baron Leasing Partners LLC · Wilmington, DEN20AEButler Aviation Inc · Houma, LAN211RHMcneely Charter Service Inc · West Memphis, ARN213PHPyro Shows Equipment LLC · La Follette, TNN217CMKlas-Kcoe LLC · Las Vegas, NVN217MLDodson Intl Parts Inc · Rantoul, KSN21DELocke-Lane Aviation LLC · Statesville, NCN21FGCalifornia Department Of Fish And Game · Sacramento, CAN21GPKolob Canyons Air Services Inc · Wilmington, DEN220TTShannair LLC · Saint Louis, MO
Back to AD 97-01-12