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.

N682JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020082 N682LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881245 N682TFAir Fleet Holdings LLC · Addison, TXBuilt 2025 · S/N 2881882 N6832FJpf Ventures LLC · Owatonna, MNBuilt 1976 · S/N 28-7790165 N6833FPatriot Aviation LLC · Huntington, INBuilt 1976 · S/N 28-7790166 N683JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020083 N683LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881246 N6847JMarkle Rick S · Waddy, KYS/N 28-7690408 N6848JPrudent Paths LLC · Hillsborough, CABuilt 1976 · S/N 28-7690409 N684APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843780 N684JAYale Companies LLC DBA · Indianapolis, INS/N 28020084 N684LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881251 N684NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881151 N6852FBlue Sky Flying Club LLC · Granger, IABuilt 1976 · S/N 28-7790167 N6854JTerwilliger John E · Hegins, PABuilt 1976 · S/N 28-7690410 N6855JLord Robert B Trustee · Lamar, COBuilt 1976 · S/N 28-7690411 N6856JWancho Brian J · El Paso, TXS/N 28-7690412 N685JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020085 N685LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881252 N685MAYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020143 N685NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881305 N6860JApm Leasing LLC · Casper, WYBuilt 1976 · S/N 28-7690413 N6861FParker Helicopters Inc · Watsonville, CAS/N 28-7790168 N6861JEwart Mark A · Shoreacres, TXBuilt 1976 · S/N 28-7690414 N6863FKaminski Joseph J · Port Orange, FLBuilt 1976 · S/N 28-7790169 N68690Locaero Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 2890203 N686CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881130 N686JMavity Michael D · Phoenix, AZBuilt 1988 · S/N 2816038 N686JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020086 N686LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881253 N686NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881152 N6876JN6876j LLC · Provo, UTBuilt 1976 · S/N 28-7690417 N6879CParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7816437 N687BHTrmg Consulting Services LLC · Edison, NJS/N 28R-7737042 N687JAYale Companies LLC DBA Hot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020087 N687LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881266 N6884JHbk Flyers LLC · Alton, ILBuilt 1976 · S/N 28-7690420 N6886JFlanders David J · Madison, WIBuilt 1976 · S/N 28-7690421 N688LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881267 N6894JPiontek Theodore J · Housatonic, MABuilt 1976 · S/N 28-7690422 N6897CSchumann Donald A · Naperville, ILBuilt 1978 · S/N 28-7890384 N689BTDoell Brad J · Elsie, NEBuilt 1977 · S/N 28-7890132 N689LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881272 N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006 N68JALost Aviators LLC · Durant, OKBuilt 2001 · S/N 2844057 N6903JGreen Valley Aerospace LLC · Lexington, VABuilt 1976 · S/N 28-7690425 N6904JGlass Michael C · Maysville, KYBuilt 1976 · S/N 28-7690426 N6908BMeriden Aviation Center LLC · Meriden, CTBuilt 1985 · S/N 28-8516050 N6909ADupont Alexander Rene · East Taunton, MAS/N 28-8516053 N6909TAlpha-One Air Service LLC · Concord, NCS/N 28-8516049

Back to AD 2016-07-21