Skip to content

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.

N608FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020208 N608FTFlorida Institute Of Technology · Melbourne, FLBuilt 1979 · S/N 28-7916328 N608GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881194 N608PTAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841217 N6090FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020155 N6091FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020156 N6095SAri Ben Aviator Inc · Fort Pierce, FLBuilt 2007 · S/N 2843662 N6096ZYoung Collin H · Spring, TXBuilt 2010 · S/N 2843678 N6097FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020157 N6098FAmeriflyers Of Texas Inc · Addison, TXBuilt 2023 · S/N 28020158 N609DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881982 N609FAStratus Air LLC · New Castle, DEBuilt 2025 · S/N 28020209 N609FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7716270 N609NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881285 N609SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881599 N60NAHampden Aviation Services Inc · Northampton, MABuilt 1980 · S/N 28-8116049 N60SULuther Frank E · Amanda, OHBuilt 2005 · S/N 2844121 N61011Inter American University Of Puerto Rico · Bayamon, PRBuilt 2008 · S/N 2844139 N610FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020110 N610NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881136 N610SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881600 N610UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020166 N6112JColeman Timothy Lynn · Port Charlotte, FLBuilt 1976 · S/N 28-7690342 N6113JOracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7690343 N611CMMasters Charles O · Garden Ridge, TXBuilt 1978 · S/N 28R-7837210 N611FTCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841223 N611JPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N 287916111 N611SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881601 N6121HRethink Creative Group LLC · Fort Worth, TXBuilt 1977 · S/N 28-7816225 N6123JBullard Dennis E · Fort Myers, FLBuilt 1976 · S/N 28-7690345 N6123QAirflair Inc · Maurice, IABuilt 1976 · S/N 28-7790065 N6124JCrews Aaron Gregory · Boone, IABuilt 1976 · S/N 28-7690346 N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255 N6127HBless Howard P · Pennsburg, PAFirst renewal noticeBuilt 1977 · S/N 28-7816226 N6129HHouk Air LLC · Waverly, OHBuilt 1977 · S/N 28-7890209 N612FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816197 N612GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881195 N612PAJenkins Phillip R Jr · Fuquay Varina, NCBuilt 1977 · S/N 28-7790518 N612WTPlane Leasing LLC · Tempe, AZBuilt 1978 · S/N 28-7816655 N613ACBas Part Sales LLC · Greeley, COBuilt 2014 · S/N 2843757 N6147HBietsch Sr Thomas R · Lincoln, CABuilt 1977 · S/N 28-7816229 N6148HHicks Braden · Manson, IABuilt 1977 · S/N 28-7816230 N614BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881856 N614SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881623 N6150JCypress Aviation LLC · Malvern, PAS/N 28-7690353 N6151HFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7890211 N6154HTravis Air Force Base Aero Club · Travis Afb, CABuilt 1977 · S/N 28-7890212 N6159HJeva Ventures LLC · Charleston, SCBuilt 1977 · S/N 28R-7837055 N615DCSheeree Corp · Wilmington, DES/N 28-7716178 N615FTFlorida Institute Of Technology · Melbourne, FLBuilt 1980 · S/N 28-8116123

Back to AD 2016-07-21