AD 2017-08-01
Registered aircraft · 572
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-08-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-08-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-08-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-08-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.
N5000XTeratorn LLC · Seattle, WAN500GFIntellectual Air LLC · Atlanta, GAN501GMSc Transport LLC · Torrance, CAN501QCQuikrete Aircraft Leasing LLC · Atlanta, GAN503GSRegistered aircraftN503GVEmmanuel Group · North Wilkesboro, NCN505DSwift Connections LLC · Los Angeles, CAN506HGKimberly-Clark Integrated Services Corp · Dallas, TXN508CKIbc Hospitality LLC · Newport Beach, CAN50JEIn50je LLC · New York, NYN50KUUnder The Stars LLC · Millington, TNN50SRegistered aircraftN50WHWhite Wing Holdings LLC · Waukegan, ILN510GTSouthwest Associates LLC · Bigfork, MTN510GVTtp Services LLC · Hillsborough, NCN510QSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN513MARichport Air LLC · Miami, FLN516GHMadero Air LLC · South Saint Paul, MNN516WWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN517DWColleen Corp · New Castle, DEN517TWGtw Corp · Jupiter, FLN518GAL3harris Technologies Flight Capital LLC · Greenville, TXN518GPG550 Msn 5051 Leasing LLC · Miami Beach, FLN51VETrousdale Aviation LLC · West Hollywood, CAN521GAGulfstream Aerospace Corp · Savannah, GAN521SBBank Of Utah Trustee · Salt Lake City, UTN522GDL3harris Technologies Flight Capital LLC · Greenville, TXN524ACPegasus Leasing LLC · Ada, MIN524AGTvpx Ars Inc Trustee · North Salt Lake, UTN524VEBank Of Utah Trustee · Salt Lake City, UTN526EMEmi Travel LLC · Tampa, FLN526GAL3harris Technologies Flight Capital LLC · Greenville, TXN526SDWilmington Trust Co Trustee · Wilmington, DEN527GAL3harris Technologies Flight Capital LLC · Greenville, TXN527JGGibbs International Inc · Spartanburg, SCN528APArrow Plane Lc · Provo, UTN529GAL3harris Technologies Flight Capital LLC · Greenville, TXN529RLRegistered aircraftN530GL3harris Technologies Flight Capital LLC Trustee · Greenville, TXN530PMEbts LLC · New York, NYN531GAL3harris Technologies Flight Capital LLC Trustee · Greenville, TXN532SPGulfstream Leasing LLC · Savannah, GAFirst renewal noticeN533GVWilmington Trust Co Trustee · Wilmington, DEN535VDelaware Aircraft Trust LLC Trustee · New Castle, DEN537NASetna Express LLC · Lincolnshire, ILN539JSG550 Msn 5390 Leasing LLC · Bay Harbor Islands, FLN542GDUnited States Air Force 645 Aesg · Wright Pat, OHN543HAir Troxel LLC · Honolulu, HIN5465MBank Of Utah Trustee · Salt Lake City, UTN549CFAvex Xvii LLC · Ft Lauderdale, FL
Back to AD 2017-08-01