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.

N729NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881024 N72DMPacific Flight Aviation LLC · Costa Mesa, CAS/N 2843471 N730AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843792 N730CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881736 N730LKBay Aero Ventures LLC · Port Clinton, OHBuilt 1977 · S/N 28-7890070 N730MABennett Robert · Lutz, FLBuilt 2024 · S/N 2881697 N730NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843887 N730SASun Aircraft Management LLC · Ormond Beach, FLBuilt 2010 · S/N 2842363 N730UOhio University · Albany, OHBuilt 2005 · S/N 2842224 N730XSbh Alliance LLC · Sauk Rapids, MNBuilt 2002 · S/N 2844066 N7310CC3 Aircraft LLC · Burnet, TXBuilt 1975 · S/N 28-7690066 N731ACAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881495 N731NDAir Shares LLC · Casper, WYBuilt 2016 · S/N 2843855 N732NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843856 N736NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881025 N739CAChristiansen Aviation LLC · Wilmington, DES/N 2881737 N739NDAir Shares LLC · Casper, WYBuilt 2017 · S/N 2843888 N73BWBravo Whiskey Holdings LLC · Lewis Center, OHBuilt 1977 · S/N 28-7816102 N73PFSinor Delbert · Ozark, MOBuilt 1981 · S/N 28-8216092 N73TSWeene Michael L · Moultonborough, NHBuilt 1985 · S/N 28-8590064 N740NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843857 N740PASkywest Leasing Inc · St George, UTBuilt 2016 · S/N 2843834 N740UOhio University · Albany, OHBuilt 2005 · S/N 2842225 N741NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881026 N741RASkyline Solutions Inc · Deland, FLBuilt 1989 · S/N 2841137 N742BBMike Sierra Bravo LLC · Port Orange, FLBuilt 1998 · S/N 2843142 N742PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881013 N743DSN743ds LLC · Chamblee, GABuilt 1977 · S/N 28-7890090 N743EDAir Adventure LLC · Sheridan, WYBuilt 1977 · S/N 28R-7837096 N743ND4 Winds LLC · Storm Lake, IABuilt 2017 · S/N 2843898 N743PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881014 N744NDAir Shares LLC · Casper, WYBuilt 2017 · S/N 2843891 N744PASkywest Leasing Inc · Saint George, UTBuilt 2018 · S/N 2881015 N745NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843860 N745PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881017 N745RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1990 · S/N 2841327 N746GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881461 N746NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881489 N746PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881018 N747CVGeorge Walker Field Inc · Bedminster, NJBuilt 1999 · S/N 2843245 N747GVPlane Sol LLC · Laredo, TXBuilt 2022 · S/N 2881586 N748PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881190 N748RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1988 · S/N 2841035 N749PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881244 N75005Spiesman William J · Austin, TXBuilt 1976 · S/N 28-7690279 N75047Dunlop Vance Trustee · Keizer, ORBuilt 1976 · S/N 28-7690285 N75048Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 28-7690286 N75049Christie Brian L · Irvine, CABuilt 1976 · S/N 28-7690287 N75059Markiewicz Mark J · Kokomo, INBuilt 1976 · S/N 28-7690289 N75082Up And Away Aviation LLC · Poughkeepsie, NYBuilt 1976 · S/N 28-7690290

Back to AD 2016-07-21