AD 98-17-01 R1
Registered aircraft · 1,201
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-17-01-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:98-17-01-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:98-17-01-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:98-17-01-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.
N629EPRockland Aviation LLC · New City, NYN629MDAircraft Holding Solutions LLC Trustee · Newark, DEN62DTN250ap LLC · Chicago, ILN62LJN62lj LLC · Fort Lauderdale, FLN62RARoyal Air Freight Inc · Waterford, MIN632JSRms Flight Services LLC · Wilmington, DEN633PJN633pj LLC · Oklahoma City, OKN635RJRoyal Air Freight Inc · Waterford, MIN63FXTrn Aviation LLC · Lewes, DEN63UCJamrock Leasing LLC · Schenectady, NYN63WJKaylan Paige Leasing LLC · Grand Junction, CON63YMSun Country Products LLC · Tampa, FLN640RBTalfin Leasing II LLC · Heflin, ALN644CKKalitta Charters LLC · Ypsilanti, MIN649TTTownes Aircraft Sales LLC · Paris, TXN64HAJoe Air LLC · Sellersburg, INN64MJM J Electric LLC · Iron Mountain, MIN64NBRcc Management & Aviation LLC · Magnolia, TXN650ABBank Of Utah Trustee · Salt Lake City, UTN650ACTen X Express LLC · Fort Myers, FLN650AHNice Trip LLC · San Juan, PRN650CBSzucs Attila · Port Orange, FLN650CGC G Bretting Manufacturing Co Inc · Ashland, WIN650CZTeam Aero LLC · Shawnee, KSN650FCOrion Igv LLC · Opa-Locka, FLN650GCBank Of Utah Trustee · Salt Lake City, UTN650HGHamlin Aviation LLC · Ormond Beach, FLN650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKN650JLEncore Jet Management LLC · San Antonio, TXN650JSEwi Tn LLC · Gallatin, TNN650KPJt95 Airways LLC · Concord, CAN650MGFalco Industries LLC · Belle Chasse, LAN650PFAircraft Holding Solutions LLC Trustee · Newark, DEN650PJSouthwest Aviation Inc · Marshall, MNN650PTBurkim LLC · Hartland, WIN650RARomeo Alpha LLC · Addison, TXN650RCRosado William · Moosic, PAN650RPRussell Air LLC · Madison, INN650RTGlobal Aero Aviation Inc · Houston, TXN650SFBas Part Sales LLC · Greeley, CON650SGMerlin One Aircraft LLC · San Antonio, TXN650TASale Reported · Greeley, COSale reported, pending cancellationN650TWKwafr LLC · Richland Hills, TXN650WAWings Aloft Incorporated · Portland, ORN650WTRiver Bay Aviation N650wt LLC · Jacksonville, FLN651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN651EJComprehensive Energy Aviation LLC · Longwood, FLN651EMWv Jet Experience LLC · Charleston, WVN651MKMaxfly Aviation Inc · Fort Lauderdale, FLN651SFN444cw Partners LLC · Spring, TX
Back to AD 98-17-01 R1