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.

N4507QFrost Aviation Services Inc · Las Cruces, NMBuilt 1979 · S/N 28-8090032 N4508XWestchester Flying Club Inc · Purchase, NYBuilt 1975 · S/N 28-7690026 N450AACentex Aero LLC Trustee · San Antonio, TXBuilt 2019 · S/N 2881256 N450CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881122 N450ZRCasey William · Celina, TXBuilt 2021 · S/N 2881481 N4510DCamwhit Air Corp · Montgomery, NYBuilt 1979 · S/N 28-8016015 N4510FWiest Donald J · Le Sueur, MNBuilt 1976 · S/N 28-7790036 N4510RMcmichael Steven G · Eden, NCBuilt 1979 · S/N 28-8090036 N4511BGcbc LLC · Norman, OKBuilt 1979 · S/N 28-8090037 N4511FLewis Brett · Madison, NJBuilt 1976 · S/N 28-7790037 N4512FChase David B Trustee · Danville, CABuilt 1976 · S/N 28-7790038 N4512LA&J Aircraft Leasing Inc · Burlington, COS/N 28-8016016 N4513DRkm Aviation LLC · Lexington, NCBuilt 1979 · S/N 28-8090038 N451TWYale Companies LLC DBA · Indianapolis, INBuilt 2023 · S/N 28020140 N4522XBlack Rain Inc · Wilmington, DES/N 28-7690028 N4524FLwg Archer LLC · Reading, PABuilt 1976 · S/N 28-7790039 N4526FReabe Spraying Service Inc · Plover, WIBuilt 1976 · S/N 28-7790040 N4528XChandler Agricultural Ind LLC Series Avation · Montgomery, ALBuilt 1975 · S/N 28-7690030 N4533XSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1975 · S/N 28-7690031 N4538QFlying V LLC · West Berlin, NJBuilt 1977 · S/N 28-7790476 N4545XMeier Gordon T · San Diego, CABuilt 1975 · S/N 28-7690033 N4547FSky Pilot Aviation Corp · Carlsbad, CABuilt 1976 · S/N 28-7790042 N454DLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020273 N454KACharlie Alpha Bravo LLC · Spring Hill, KSS/N 28-7790454 N454TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020242 N454XThree Wing Flight School LLC · Stratford, CTBuilt 1978 · S/N 28-7890318 N4550DCharlymark 7 Flight Club LLC · Jamaica, NYBuilt 1983 · S/N 28-8390041 N4551FViser Timothy A · Cleveland, TNBuilt 1976 · S/N 28-7790044 N4554XSchwartz Michael · Bethel, CTBuilt 1975 · S/N 28-7690035 N455BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010039 N455HFlying 20 Club Inc · Newtown, CTBuilt 2000 · S/N 28-43393 N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506 N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353 N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039 N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034 N457AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881757 N457ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010057 N457TThompson Ernest W Jr · Yukon, OKBuilt 1976 · S/N 28-7690218 N4580FRegistered aircraftBuilt 1976 · S/N 28-7790045 N4581XRegistered aircraftBuilt 1975 · S/N 28-7690042 N45832Arenal Patrick T · Granbury, TXBuilt 1977 · S/N 28-7890048 N4584FStorm Flying Service Inc · Webster City, IAFirst renewal noticeBuilt 1976 · S/N 28-7790047 N4585XFrost Aviation Services Inc · Las Cruces, NMBuilt 1975 · S/N 28-7690043 N4589XSek LLC · Concordia, MOS/N 28-7690045 N458AArcher Aero LLC · Wilmington, DEBuilt 2014 · S/N 2843799 N458ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010058 N458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 28-43022 N4593XClubs 2 LLC · Calabasas, CABuilt 1975 · S/N 28-7690046 N4594F181 Corporation · Charlotte, NCBuilt 1976 · S/N 28-7790048 N4595FSchroeder Herbert D · Plano, TXBuilt 1976 · S/N 28-7790049

Back to AD 2016-07-21