Registered aircraft · 5,443

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

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:2016-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21') ORDER BY n_number

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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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:2016-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
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.

N84577Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1981 · S/N 28-8216052 N8458HGansemer William L · Mason City, IABuilt 1981 · S/N 28-8290053 N845GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881067 N845TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020145 N8460YOmarco LLC · Woodbridge, VABuilt 1981 · S/N 28-8290057 N8461USfb Aviation Services LLC · Edmond, OKBuilt 1981 · S/N 28-8216058 N8461WHernandez Luis A · Longview, TXBuilt 1981 · S/N 28-8216059 N84625Our Archer LLC · Rindge, NHBuilt 1981 · S/N 28-8290059 N8463FMission Flight · El Monte, CAS/N 28-7716003 N8465FEvans Danny J · Clayton, NCS/N 28-7716005 N8466BPaphos Airways LLC · Farmingdale, NYBuilt 1981 · S/N 28-8216063 N8466FGarcia Oscar E · Redding, CAS/N 28-7716006 N8466HOsgood Richard E · Boscawen, NHBuilt 1981 · S/N 28-8290062 N8467BAthens Aero Club Inc · Athens, OHBuilt 1981 · S/N 28-8290064 N8467FMcclure Richard A · Victoria, TXS/N 28-7716007 N84699Skyknights Of Western Ky Inc · Calvert City, KYBuilt 1981 · S/N 28-8290067 N8469HBolter Aviation Inc · Lewisville, TXS/N 28-8216065 N8469TLally Thomas J · Manomet, MABuilt 1981 · S/N 28-8216066 N846AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881846 N846TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020146 N8471CC S & W Aviation Inc · Fall Branch, TNS/N 28-7690142 N8471SReigle Daniel F · Crown City, OHBuilt 1981 · S/N 28-8216071 N8471TGorman Aviation LLC · Bartlesville, OKBuilt 1981 · S/N 28-8290071 N8473BWrightsville Aviation Partners LLC · Wilmington, NCS/N 28-8290070 N847AAAb Prop Plan I LLC · Metairie, LABuilt 2025 · S/N 2881847 N847AMCti Aircraft Leasing LLC · Memphis, TNS/N 2881303 N847TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020147 N8483FPlanchon Ben P · Menifee, CABuilt 1976 · S/N 28-7790250 N8484FAero Activites LLC · Edgewood, NMBuilt 1976 · S/N 28-7790251 N848AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881848 N848MAIcarus Flying Academy LLC · Farmingdale, NYBuilt 2026 · S/N 28020270 N848TCTexas State Technical College · Waco, TXBuilt 2023 · S/N 28020148 N8494FPlane Viewing LLC · Colbert, WABuilt 1976 · S/N 28-7790252 N8495FKing Robert M · Fall River Mills, CABuilt 1976 · S/N 28-7790253 N8496FSoriano Juan H · Travelers Rest, SCBuilt 1976 · S/N 28-7790254 N849AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881849 N84ARArc Aviation LLC · Auburn, ALBuilt 1977 · S/N 28R-7737099 N8503EB&B Aviation Holdings LLC · Pembroke Pines, FLBuilt 1976 · S/N 28-7690175 N850FSParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020072 N850NCRegistered aircraftBuilt 2002 · S/N 2844074 N850PUTrustees Of Purdue University · West Lafayette, INS/N 2881323 N851AAAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881850 N851PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843942 N851PUTrustees Of Purdue University · West Lafayette, INS/N 2881324 N851WTFowler Clinton Lewis · Conroe, TXBuilt 1976 · S/N 28-7790077 N852DXGlobe Aero LLC · Lakeland, FLBuilt 2025 · S/N 2881900 N852PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843943 N852PUTrustees Of Purdue University · West Lafayette, INS/N 2881325 N853AAAb Prop Plane I LLC · Metairie, LABuilt 2026 · S/N 28010044 N853NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881369

Back to AD 2016-07-21