AD 2017-20-01
Registered aircraft · 341
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:2017-20-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-01')
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:2017-20-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2017-20-01') 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.
N606WJHawker 800xp LLC · Fort Lauderdale, FLN616LKAvon Aero LLC · Orlando, FLN620KEAir Coryell Flight LLC · Springfield, MON626BMRegistered aircraftN626JCSeascape Air LLC · Irvine, CAN629BKKeselowski Transportation LLC · Statesville, NCN63UCJamrock Leasing LLC · Schenectady, NYN63WJKaylan Paige Leasing LLC · Grand Junction, CON63YMSun Country Products LLC · Tampa, FLN649TTTownes Aircraft Sales LLC · Paris, TXN64MJM J Electric LLC · Iron Mountain, MIN650RARomeo Alpha LLC · Addison, TXN655MDMargarita Flights LLC · Longwood, FLN655TCTlc Aircraft Leasing LLC · Vero Beach, FLN667WJConnell Blue LLC · Berkeley Heights, NJN669RARoyal Air Freight Inc · Waterford, MIN66ZBCharter Equipment Leasing LLC · Bellevue, WAN673HBSigma Equity LLC · San Francisco, CAN676GHNoll Air LLC · Orlando, FLN680JSBank Of Utah Trustee · Salt Lake City, UTN68YBCzzc Aviation LLC · Tucson, AZN699BGWord Of Life Christian Center Inc · Darrow, LAFirst renewal noticeN69BSDspa LLC · Baton Rouge, LAN6NRSdi Aviation LLC · Rhinelander, WIN700PGAviation Xx LLC · Wilmington, DEN700SRMd Jet Aviation Services Inc · Wilmington, DEN707JQPinnacle Aviation Group LLC · Wilmington, DEN708SPLr4514 LLC · Boca Raton, FLN70TTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN710PPaccar Mexico Logistics Inc · Seatac, WAN711LTBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLN716DBCervenka Debra A · Santa Rosa Beach, FLN717LAAdcnt Management Co LLC · Dallas, TXN719HGFlightworks Inc · Kennesaw, GAN719SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN71AHAircraft Holding Solutions LLC Trustee · Newark, DEN724FSSmith Frank Ford Jr · Wilmington, DEN724LTRegistered aircraftN729WLBearcat Air LLC · Solon, OHN72FCAlliance Aviation Group LLC · Wilmington, DEN732AADjcj LLC · Nashville, TNN733GBuzick Air LLC · Bardstown, KYN740TFTop Gun Air LLC · Pompano Beach, FLN744ARTop Air Texas LLC · Glendale, CAN745MCMiradair LLC · Lake George, NYN747BWOxford LLC · Fort Lauderdale, FLN751JCCbr Aviation LLC · Delaware, OHN757TRRegistered aircraftN75ABRivers Equipment III LLC · Nashville, TNN75JMJast Air LLC · Wilsonville, OR
Back to AD 2017-20-01