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.

N327NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881657 N3289QTrident Aircraft Leasing LLC · Easton, MDBuilt 1977 · S/N 28-7716146 N328GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881115 N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164 N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147 N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447 N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991 N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512 N32KHN32kh LLC · Quincy, WAS/N 287790384 N32NAHampden Aviation Services Inc · Northampton, MABuilt 1982 · S/N 28-8316023 N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373 N331MKStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843477 N331PAHale Enterprises Inc · Carbondale, ILBuilt 2002 · S/N 2843514 N3323MTalbot Larry · Bradenton, FLBuilt 1977 · S/N 28-7890296 N3326MMcray Brett H · Sugar Land, TXBuilt 1977 · S/N 28R-7837111 N3327MNearhoof Jeremy R · The Woodlands, TXBuilt 1977 · S/N 28R-7837112 N332BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881083 N332PABird Acquisition LLC · Phoenix, AZS/N 2843515 N3331QEvangelista Ronald · Castle Rock, COBuilt 1977 · S/N 28-7716148 N3334QViking Aerial Photography LLC · Zionsville, INBuilt 1977 · S/N 28-7790449 N333NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881782 N333PGAty Aviation Inc · Watertown, SDBuilt 1977 · S/N 28R-7737114 N3343QGallmeyer Vernon H DBA · Louisville, COS/N 28-7716151 N3344QGrinch Robert J · Ridgewood, NJBuilt 1977 · S/N 28-7790452 N334ACRegistration Pending · Farmingdale, NYRegistration pendingBuilt 2005 · S/N 2842219 N334BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881084 N334GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881116 N334NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881793 N335ACRegistration Pending · Fort Pierce, FLRegistration pendingBuilt 2006 · S/N 2842274 N335BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2018 · S/N 2881085 N335MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881090 N3360MStyer David · Pendleton, ORBuilt 1977 · S/N 28-7816339 N336BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881098 N336MAHot Wings Aviation LLC · Fishers, INBuilt 2024 · S/N 28020175 N336MKNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881087 N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297 N337BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881099 N337FBMa Aviation Group LLC · Farmingdale, NYBuilt 2003 · S/N 2843550 N337GAtp Taa LLC · Wilmington, DEBuilt 2020 · S/N 2881424 N338BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881263 N338MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881096 N338PAFl Ventures I LLC · Winter Park, FLBuilt 2002 · S/N 2844076 N3396QRomanair Wdr Inc · Winder, GABuilt 1977 · S/N 28-7790455 N339BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881525 N339DALink Aviation LLC · Eau Claire, WIBuilt 2002 · S/N 2844077 N339MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881097 N339NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2006 · S/N 28010012 N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136

Back to AD 2016-07-21