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.

N30067Limbacher John P II · Cookeville, TNBuilt 1978 · S/N 28-7990083 N3006KPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7990247 N3006WJimenez Carlos · Davie, FLBuilt 1979 · S/N 28-7990360 N3007BStanly Business Consultants LLC · Albemarie, NCBuilt 1978 · S/N 28-7990134 N3007KC & B Partnership · Grand Junction, COFirst renewal noticeBuilt 1978 · S/N 28-7990248 N3007THorizon Air Ventures LLC · Fincastle, VABuilt 1997 · S/N 2843072 N3008AMackenzie David Webb · Wilmington, DEBuilt 1978 · S/N 28-7916104 N3008BSedberry Jason A DBA · Kokomo, INBuilt 1978 · S/N 28-7990135 N3008FShepherd Michael D · Rock Hill, SCBuilt 1978 · S/N 28-7916210 N3008UNaperville Flying Club Inc · Woodridge, ILBuilt 1979 · S/N 28-7990333 N3009UEdgar Holly A · Tigard, ORBuilt 1979 · S/N 28-7990334 N300DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842180 N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076 N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170 N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395 N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085 N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182 N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171 N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335 N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284 N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298 N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184 N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398 N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284 N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980 N3020SAndre Frazier LLC · Anacortes, WABuilt 1979 · S/N 28-7916295 N3021CUnited States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28-7916137 N3021HWilcox Kenneth P · Peachtree City, GABuilt 1978 · S/N 28-7990200 N30222Nass Aviation Inc · Selbyville, DEBuilt 1978 · S/N 28-7990086 N30230N30230 Aircraft Holdings LLC · North Charleston, SCBuilt 1978 · S/N 28-7990088 N3023CBlack Cloud Aviators Inc · Dubois, PABuilt 1978 · S/N 28-7990148 N3023TInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-7916299 N30249Campbell Donald R · Lawrenceburg, KYBuilt 1978 · S/N 28-7890451 N3024CCash Management Consulting LLC · Granite Springs, NYBuilt 1978 · S/N 28-7990149 N3024MTremie Chad M · Sulphur, LABuilt 1977 · S/N 28-7890286 N3025CWonnenberg Douglas D · Menoken, NDBuilt 1978 · S/N 28-7990150 N3025QTamborelli Keith · Kulpmont, PABuilt 1979 · S/N 28-7916285 N30260Schubert Mark J · Watkins, COBuilt 1978 · S/N 28-7890452 N3027SG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 28-7990310 N3028ERegistration Pending · Philadelphia, PARegistration pendingBuilt 1978 · S/N 28-7916168 N3028MLittle Robert · Ocala, FLBuilt 1978 · S/N 28-7816397

Back to AD 2016-07-21