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.

N43753Glacier View Aviation LLC · Kalispell, MTBuilt 1977 · S/N 28-7890009 N43755Mang Aero Club Inc · Belleville, MIBuilt 1977 · S/N 28-7890010 N43756Acme Aviation LLC · North Beach, MDBuilt 1977 · S/N 28-7890011 N4376HCharlevoix Flying Club Inc · Petoskey, MIBuilt 1984 · S/N 28-8490110 N43770White County Flying Club Inc · Fairfield, ILBuilt 1977 · S/N 28-7890012 N43774Freeman James A III · Columbus, OHBuilt 1977 · S/N 28-7890013 N43779Chandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 28-7890014 N4377PClardy Alexander Tanner · Buellton, CABuilt 1984 · S/N 28-8516004 N4377SPenn Ohio Flying Club Inc · New Wilmington, PABuilt 1984 · S/N 28-8516005 N4377WCameron Jarred · Midvale, UTBuilt 1984 · S/N 28-8516006 N43788Logansport/Cass County Airport Authority · Logansport, INBuilt 1977 · S/N 28-7890016 N4378BMiles John H III · Georgetown, TXBuilt 1984 · S/N 28-8590002 N4378NFlight School Inc · Spring, TXBuilt 1984 · S/N 28-8590012 N43790Fersa Pierre · Windermere, FLBuilt 1977 · S/N 28-7890017 N43793Casanova LLC · The Plains, VAS/N 28R-7737135 N43798Susong Charles W · Afton, TNBuilt 1977 · S/N 28R-7737130 N4379DRustambekov Elzotbek · Providence, RIBuilt 1985 · S/N 28-8516029 N4379MVonrichthofen Philip D · Canton, CTBuilt 1984 · S/N 28-8590026 N4379VAir Mods And Repair Corp · Robbinsville, NJBuilt 1984 · S/N 28-8516010 N437MBMike Bravo LLC · Olathe, KSBuilt 2022 · S/N 2881597 N43801Schnoor Max M Jr · Cambridge, MDBuilt 1977 · S/N 28-7890018 N43802Armstrong David · North Pole, AKBuilt 1977 · S/N 28-7890019 N43808Cherokee Flying Club Inc · E Longmeadow, MABuilt 1977 · S/N 28-7890022 N43810Lain Snow LLC · Ocean Isle Beach, NCBuilt 1977 · S/N 28-7890023 N43812Schiffer Todd · Franklin, PABuilt 1977 · S/N 28-7890024 N43813Gq Aviation LLC · Cherry Hill, NJBuilt 1984 · S/N 28-8516017 N43817Fraser Roger Douglas · Amelia Island, FLBuilt 1977 · S/N 28R-7737136 N4381FN4381f LLC · Wilmington, DES/N 28-8516015 N4381LAir-Mods Flight Academy Inc · Robbinsville, NJBuilt 1984 · S/N 28-8516016 N4381SPilatus Aircraft USA Ltd · Broomfield, COBuilt 1984 · S/N 28-8590014 N4382JGood Flight Aviation LLC · Stockton, CABuilt 1984 · S/N 28-8516018 N43836Robinson Marissa · Burgettstown, PABuilt 1977 · S/N 28-7890026 N43839Legacy Aviation LLC · Sullivan, INBuilt 1984 · S/N 28-8590020 N4383FRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1976 · S/N 28-7790025 N43843Koenig David J · Crosslake, MNBuilt 1977 · S/N 28-7890028 N4384FEes LLC · Thomaston, CTS/N 28-7790026 N4385GSouthwind Global Aviation Inc · Moundridge, KSBuilt 1985 · S/N 28-8590045 N4385MCowlin Christopher S · Hollywood, SCBuilt 1984 · S/N 28-8590025 N4385WMacair Aviation LLC · Xenia, OHBuilt 1984 · S/N 28-8516002 N4386MPerez Gabriel R · Dripping Springs, TXBuilt 1985 · S/N 28-8590027 N43885Paris Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8516032 N4388CAlbert Lea Airport Inc · Albert Lea, MNBuilt 1984 · S/N 28-8516021 N43899Smtm Holdings Inc · Wilmington, DEBuilt 1985 · S/N 28-8516033 N4389VLeonard Nicholas Robert Eugene · Monument, COBuilt 1985 · S/N 28-8590028 N438GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881178 N438RMRocky Mountain College · Billings, MTBuilt 2019 · S/N 2881095 N438SLGriffith Aviation Inc · Griffith, INBuilt 1979 · S/N 28-7916276 N4390SCandace A Larned Enterprises Inc · Long Beach, CABuilt 1985 · S/N 28-8516031 N4392XMountain View Aviation Inc · Honesdale, PABuilt 1975 · S/N 28-7690004 N43948Jl3 Aviation LLC · Blue Springs, NEBuilt 1977 · S/N 28-7890030

Back to AD 2016-07-21