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.

N985NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881903 N986FBBenzie Fred J III · Marquette, MIBuilt 1977 · S/N 28-7790074 N986GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881492 N9871KBeverly Flight Center LLC · Middleton, MABuilt 1977 · S/N 28-7816200 N9872KWolvestown LLC · Humble, TXS/N 28-7816201 N9881KHickman David R · Port Orange, FLBuilt 1977 · S/N 28-7890192 N9886KSmart03 LLC · Kissimmee, FLBuilt 1977 · S/N 28-7816205 N988AMM & G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 2881579 N988GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881493 N988JFMcdaniel Patrick D · State College, PABuilt 1999 · S/N 2843287 N9890KWilliams Robert · Dawsonville, GABuilt 1977 · S/N 28R-7837046 N98DBDb Aero Restoration LLC · Wilmington, OHBuilt 1977 · S/N 28-7790474 N98HSSaunders Robert A · Barrington, RIBuilt 1997 · S/N 2843086 N98MVFargo Jet Center LLC · Fargo, NDBuilt 1995 · S/N 28-90216 N98PFDakota Acre Farms Inc · Denhoff, NDBuilt 1985 · S/N 28-8516044 N9900KLong Jimmie Brian · Cropwell, ALBuilt 2005 · S/N 2843617 N9908KG&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7890198 N990AMAmerican Asset Leasing LLC · Aurora, ORBuilt 2022 · S/N 2881580 N990FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881649 N990SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881877 N991AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843807 N991BJSilver Express Co · Miami, FLBuilt 1986 · S/N 28-16008 N991FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881869 N991TALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 2021 · S/N 28020029 N991VTCrosswinds Flying Club Inc · Bloomington, ILBuilt 1978 · S/N 28R-7837267 N992FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881693 N993FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881830 N993GAtp Aircraft 9 LLC · Wilmington, DES/N 2881494 N994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089 N994FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881831 N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037 N995FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881883 N996FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881598 N997CWDanesy Dorothea H · Pasadena, CABuilt 1977 · S/N 28-7716049 N997FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881954 N997SGRas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816562 N998CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881297 N998FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881960 N999KDKretschmer Fred L Jr · Vero Beach, FLS/N 28-7790181 N99YGInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 287816625 N9BVVenice Aero Club Inc · Nokomis, FLS/N 28-8190072 N9FNMyf Holdings LLC · San Diego, CABuilt 1978 · S/N 28R-7837153 N9PMNdlebe Isabella L · Okemos, MIBuilt 1977 · S/N 28R-7837115

Back to AD 2016-07-21