AD 98-15-13
Registered aircraft · 2,358
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:98-15-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:98-15-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:98-15-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:98-15-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.
N220FSHonker Air LLC · Huntingburg, INN220KWAirselect LLC · West Point, IAN220RARoyal Air Freight Inc · Waterford, MIN220VTExec III LLC · Maineville, OHN221FTTortuga Ventures LLC · Covington, LAN221GSendero Aviation Services LLC · Dublin, TXN221MMGordon Truck Centers Inc · Pacific, WAN222AGKryptonite Industries LLC · Golden, CON222CYBlue Star Gas Fleet Services Co · Santa Rosa, CAN222KCU S Army - Owner · New Century, KSN222PVJ Turbines Inc · Wilmington, DEN223JRBierlein Aviation LLC · Midland, MIN223MWWhiskey Tango LLC · Midland, TXN223RCSailfish Aviation LLC · Little Mountain, SCN223TPAviapa LLC · Doylestown, PAN224CCRanger Aviation LLC · Houston, TXN225CMMcmillin Sce LLC · El Cajon, CAN226BKAvtran LLC · Clayton, MON2274LN2274l LLC · Booneville, MSN227DCEllen Vineyards Inc · Sanger, CAN227NCCausebe LLC · Black Mountain, NCN228AJTriton Airplane Leasing LLC · Wilmington, DEN228RCPuro Humo Aviation LLC · Miami, FLN2297CRaviator II LLC · Dallas, TXN22BBSpillman Robert · Port Orange, FLN22FMjsmm LLC · Santa Rosa Beach, FLN22GSGbs Aviation LLC · Fort Worth, TXN22MTHagler Air LLC · Augusta, GAN22NDynamic Avlease Inc · Bridgewater, VAN22PEAdamb200 Holdings LLC · Broken Bow, OKN22VRHot Rock LLC · Dover, DEN2316National Nuclear Security Administration · North Las Vegas, NVN2317National Nuclear Security Administration · North Las Vegas, NVN2319National Nuclear Security Administration · Las Vegas, NVN234KW405 Transportation Partners LLC · Edmond, OKN2354YUtah Department Of Transportation · Salt Lake City, UTN235LCRosado Aviation Inc · Moosic, PAN236CPArtic Legacy Aviation LLC · Anchorage, AKN236JSIsr Aviation LLC · Wilmington, DEN237KConquest Express LLC · Libertyville, ILN239JVRim Group LLC · Waterford, MIN23SYVlf Air LLC · Calabasas, CAN23WSDovey Air Inc · Birmingham, MIN241PHPhi Health LLC · Tempe, AZN241VVWorldwide Aviation LLC · Springfield, MON242LFDavis Aviation Inc · Brandon, MSN242ZAN667kt LLC · Lewes, DEN243AMAirmed International LLC · Birmingham, ALN243CKKalitta Air LLC · Ypsilanti, MIN243MHAllen Contracting Inc · Oklahoma City, OK
Back to AD 98-15-13