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.

N40024Teton Leasing LLC · Pocatello, IDBuilt 1977 · S/N 28R-7737128 N40037Pars Avn Corp · Wilmington, DES/N 28-7816003 N40042Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816004 N40045Lawson William · Somerset, WIBuilt 1977 · S/N 28-7816006 N40057Hovnanyan Ari · Van Nuys, CABuilt 1977 · S/N 28-7716313 N40058Johnson Cassandra · Temecula, CABuilt 1977 · S/N 28-7816007 N40060Marshall Loraine · Independence, KYBuilt 1977 · S/N 28-7816009 N40062Kiwi Air Inc · Sausalito, CAS/N 28-7890003 N40068Van Houten Bradley Thomas · Naples, FLBuilt 1977 · S/N 28R-7737131 N40069Brown Willard Jr · Far Hills, NJS/N 28-7890170 N40070Penski Christopher E · Ocala, FLBuilt 1977 · S/N 28-7816012 N400JRAirspeed Investments LLC · Springfield, TNBuilt 1982 · S/N 28-8316007 N400UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020228 N4011QKolb Michael J · Glenside, PABuilt 1977 · S/N 28R-7737059 N401HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020283 N401PASkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843444 N401ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881647 N4027FSullivan Matthew Thomas · Athens, TXBuilt 1976 · S/N 28-7790001 N402AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843737 N402BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020285 N402WBNew England Airlines Inc · Westerly, RIBuilt 1977 · S/N 28-7790524 N403ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881648 N40451Gallego Javier · Diamond Bar, CABuilt 1977 · S/N 28-7816015 N404AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881813 N404CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881109 N404NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010004 N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002 N4058QPerry John S Jr · Hudson, WIS/N 28-7790469 N405AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843738 N405CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881110 N405NDSmith Michael Christopher · Concord, NCBuilt 2004 · S/N 2844113 N405SGriffing Flying Service Inc · Port Clinton, OHBuilt 1986 · S/N 2890015 N405SBSky Bright Inc · Gilford, NHBuilt 1978 · S/N 28-7916139 N4060FJones Brent M · Las Vegas, NVS/N 28-7790003 N4065529 Uniform LLC · Nashville, TNBuilt 1977 · S/N 28-7890005 N4065QZajdel Edwin J Jr · Ocean City, MDBuilt 1977 · S/N 28R-7737060 N40670Cavorite Aviation LLC · Lehi, UTBuilt 1977 · S/N 28-7890007 N40679Skipper Consulting LLC · Athens, ALBuilt 1977 · S/N 28R-7737132 N406AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843739 N406DRKent Keith M · Ellijay, GABuilt 1978 · S/N 28-7916072 N406FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020206 N406MACti Aircraft Leasing LLC · Memphis, TNBuilt 2019 · S/N 2881123 N406PGShumacker James N · Carmel, INBuilt 2021 · S/N 2881449 N407FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020207 N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216 N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545 N4085QWarrior 85q LLC · Vero Beach, FLS/N 28-7716170 N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119 N408LWParis Air Inc · Vero Beach, FLS/N 28-7716114 N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669

Back to AD 2016-07-21