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.

N425PABas Part Sales LLC · Greeley, COBuilt 2001 · S/N 2843474 N4262Regal Dent Inc · Goshen, NYFirst renewal noticeBuilt 2006 · S/N 2843647 N4268FWindt Edward A Jr · Chester, NJS/N 28-7790008 N426PAN426pa LLC · New Orleans, LABuilt 2001 · S/N 2843475 N426RMRocky Mountain College · Billings, MTBuilt 2002 · S/N 2843529 N427RMWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 2843531 N4280FRt Flyers LLC · Shakopee, MNBuilt 1976 · S/N 28-7790009 N428BBPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010046 N428MRepanshek David J · Hertford, NCBuilt 1979 · S/N 28-8090169 N428NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010014 N428PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843476 N4291SHobart Aviation Inc · Akron, OHBuilt 1982 · S/N 28-8316036 N4292YWalters Jason · Palm Springs, CABuilt 1983 · S/N 28-8390037 N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040 N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056 N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050 N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058 N4298VLuitjens Jabob J · Cascade Locks, ORS/N 28-8316059 N42KRDonnelly Charles A · Browns Mills, NJBuilt 1977 · S/N 28-7716295 N4300SLcc West LLC · Freehold, NJS/N 28-8316064 N4300UUltimate Thermal Inc · Omaha, NES/N 28-8390053 N4302TRiley Thomas J · West Grove, PABuilt 1983 · S/N 28-8316065 N43037Miloud Chadd K · Fort Worth, TXBuilt 1983 · S/N 28-8316068 N4304DPops Aviation LLC · Pace, FLS/N 28-8316070 N43055Plain Plane Partners LLC · Wilmington, DEBuilt 1983 · S/N 28-8390066 N43056Lucier Laura M · Houston, TXBuilt 1983 · S/N 28-8390067 N43060Jefferson City Aviation Inc · Jefferson City, MOBuilt 1983 · S/N 28-8316074 N4306BPv Rec Flight LLC · West Chester, PABuilt 1983 · S/N 28-8390068 N4307MCannon Mark C · Shelbyville, TNBuilt 1983 · S/N 28-8316076 N4308KPetsche Renee A · Round Rock, TXFirst renewal noticeBuilt 1983 · S/N 28-8316082 N4308PPilots Flying School LLC · Englishtown, NJBuilt 1983 · S/N 28-8390069 N43091Reid Royce · Ferndale, WABuilt 1983 · S/N 28-8390076 N43095Rogers Danny · Florence, KYBuilt 1983 · S/N 28-8390077 N4309XFizer Charles Sutton IV · Orlando, FLBuilt 1983 · S/N 28-8316086 N430DSDelaware State University · Dover, DEBuilt 1978 · S/N 28-7816517 N430NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010017 N430RMRocky Mountain College · Billings, MTBuilt 2006 · S/N 2843625 N430TCNorth Star Aviation Inc · Mankato, MNBuilt 2018 · S/N 2881089 N430ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881671 N4311ALopez Jennifer L · Fort Rucker, ALBuilt 1983 · S/N 28-8316089 N4311VWayne Braden M · Greenbrier, ARBuilt 1983 · S/N 28-8390079 N43124Beale Air Force Base Aero Club · Beale Afb, CABuilt 1983 · S/N 28-8316094 N43128United States Air Force Owner · Hanscom Afb, MABuilt 1983 · S/N 28-8316095 N4312FUniversal Aviators Academy Inc · El Monte, CABuilt 1977 · S/N 287790010 N4312PSkypro Industries Inc · Jacksonville, FLS/N 28-8316093 N4313DPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1983 · S/N 28-8390082 N4313FJs Partner Consulting LLC · Stamford, CTBuilt 1976 · S/N 28-7790011 N43141Salaues Francisco · Canyon Country, CABuilt 1983 · S/N 28-8316109 N4314PLeverone Joseph P Jr · Minneapolis, MNBuilt 1983 · S/N 28-8316108 N4315VCustom Services Group Inc · Fort Walton Beach, FLBuilt 1983 · S/N 28-8390088

Back to AD 2016-07-21