AD 90-02-13
Registered aircraft · 3,863
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-02-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:90-02-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:90-02-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:90-02-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.
N21FC310 Pals LLC · Lake City, FLN21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN21GFBas Part Sales LLC · Greeley, CON21HAEngle Scott · Plymouth, MNN21KBLow Carl S III · Aurora, TXN21KDMrd Aviation LLC · Windsor, CON21MTTarrant County College · Fort Worth, TXN21SGTwo One Sierra Golf LLC · Seattle, WAN21SSMidwest Corporate Air Inc · Bellefontaine, OHN21WUDallas Aero & Sales LLC · Poplar, MTN2207FAnderson Mike DBA · Muskogee, OKN220BRSimmonds Gary Bert · San Antonio, TXN220GDJoseph M De Lecce Trustee · Prather, CAN220HDAce Transport Service Inc · Wilmington, DEN2211FSkyvault Holdings LLC · Saint Petersburg, FLN2211QHill Jeffrey A · Bridgeport, WVN2212ASiewart Michael · Columbus, OHN2214Q421 Partners · Delphi, INN221MBMendenhall Carl T · Sophia, NCN2221QAviation Sales And Charter LLC · Dover, DEN222AWJust Planes Inc · Hobbs, NMFirst renewal noticeN222AXGraven Timothy G · Foristell, MON222BJFlight Smith LLC · Orem, UTN222DJGarone Michael A · Miami, FLN222FGSkytravel LLC · Victoria, TXN222FWLindsey Daniel Rey · Clovis, NMN222LTwo Motor Odor LLC · Paris, TXN222PEPacific Air Charters Inc · Honolulu, HIN222PLAnderas Per R · Green Bay, WIN222PRFlying South LLC · Wilmington, DEN222RDAviation Consultants Inc · San Luis Obispo, CAN222RMKelco LLC · Helena, MTN222SVEllsworth Jason W · Hamilton, MTN2232FPritchard Dale G · St Maries, IDN2235QSparx Logistics USA Ltd · Charlotte, NCN2236QWoods Leland W · Klamath Falls, ORN223HWatson James E Jr · Victor, CON223PBHyannis Air Service Inc · Hyannis, MAN2240FFenco Holdings Inc · Cheyenne, WYN2241FHaag Douglas A · Collierville, TNN2244FSky King 44f LLC · Florence, SCN2249MSky Visions Photography LLC · Manitowoc, WIFirst renewal noticeN2252FAdh Enterprises Inc · Sherman, ILN2256FWesellairplanes.Com Inc · Wilmington, DEN2259FDemon21 LLC · Granville, OHN225LRice James M · Austin, TXN2265FRegistration Pending · Wilmington, DERegistration pendingN2266FTechnical Education Services Inc · Virginia Beach, VAN2268FKephart Peter J · Washington, MON226HPRegistration Pending · Valdosta, GARegistration pending
Back to AD 90-02-13