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.

N4900URegistration Pending · Rockville, MDRegistration pendingBuilt 2005 · S/N 2842240 N4930UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842241 N4937FRegistered aircraftBuilt 1976 · S/N 28-7790075 N493DSDelaware State University · Dover, DEBuilt 1983 · S/N 28-8416011 N493MAGreat Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843486 N4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842228 N494LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020022 N4958FJuoni Joshua Charles · Oklahoma City, OKBuilt 1976 · S/N 28-7790078 N495DSDelaware State University · Dover, DEBuilt 1997 · S/N 2844012 N495LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020023 N496DSDelaware State University · Dover, DEBuilt 1993 · S/N 2816105 N496LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020074 N4979FEdward Jones Risk Placement Corp · Voorhees, NJS/N 28-7790081 N497DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816567 N497LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020075 N4980UUniveristy Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842229 N4984RGingrich Fredric D II · Indianapolis, INBuilt 1977 · S/N 28-7890047 N4990UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842230 N49PTWright Wrench Aviation LLC · Cedar City, UTBuilt 1997 · S/N 2843094 N4THIm Plane Crazy Ltd · Wilmington, DEBuilt 1978 · S/N 28-7890499 N4VTUp And Up Aviation LLC · Magnolia, TXBuilt 1985 · S/N 28-8616015 N4YPBobs Biz Ltd · Minster, OHBuilt 1999 · S/N 2843284 N500AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020001 N500FWWohltman Valerie A Trustee · Effingham, ILBuilt 1979 · S/N 28-7990431 N500GSCloud Chaser Aviation LLC · Chesnee, SCBuilt 2005 · S/N 2843611 N500LHParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916240 N500VBParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020101 N501MAContinental Aerospace Technologies Inc · Mobile, ALBuilt 2021 · S/N 2881479 N502NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2021 · S/N 2881475 N503AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020003 N5040POld Seale Properties LLC · Ft Mitchell, ALBuilt 2001 · S/N 2843447 N504APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843751 N504AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020004 N504NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2021 · S/N 2881476 N505AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020005 N505GSVolar Corp · El Cajon, CABuilt 1977 · S/N 28-7890275 N505SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881420 N50637Great Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843419 N506NDUniversity Of North Dakota · Grand Forks, NDS/N 2881780 N506RBChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 2843092 N507AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020006 N507GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881179 N507SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881421 N508AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020007 N508DXPiper Aircraft Inc · Vero Beach, FLS/N 28010108 N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281 N509AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2020 · S/N 28020008 N509AMAmerican Asset Leasing LLC · Aurora, ORBuilt 2022 · S/N 2881581 N509DXPiper Aircraft Inc · Vero Beach, FLS/N 28010109 N50HFParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020135

Back to AD 2016-07-21