Registered aircraft · 40,471

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N9585JHaj Aviation Inc · Cypress, TXNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 28-3724 N9585LEight5lima LLC · Phoenix, AZBuilt 1974 · S/N AA5-0585 N9585VHarrington Aviation LLC · Scarborough, MEBuilt 1974 · S/N 17264387 N9585WRandolph Richard A · Gallipolis, OHBuilt 1967 · S/N 28-23031 N9586DHauser Nathan S · Newark, DES/N 22-6493 N9586JGeorge Neal E · Crestview, FLBuilt 1966 · S/N 28-3725 N9586LJones Jr Lee S · Kearneysville, WVBuilt 1974 · S/N AA5-0586 N9586WAlpha 3 LLC · Troy, KSBuilt 1967 · S/N 28-23032 N9587JScott Jeremy A · Newark, OHBuilt 1966 · S/N 28-3726 N9587SReberg Timothy J · Bayport, MNBuilt 1965 · S/N 5 N9587UKramer Andrew J · Sacramento, CAS/N AA5A-0087 N9587VPinnick Brent E · West Baden Springs, INBuilt 1974 · S/N 17264389 N9588DGardner Brian D · Mesa, AZS/N 22-6495 N9588URgm LLC · Missoula, MTS/N AA5A-0088 N9588VKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17264390 N9589HFryar Scott D · Starke, FLBuilt 1975 · S/N 17266248 N9589LVincent Jared H · Fairhope, ALBuilt 1974 · S/N AA5-0589 N958LRegistered aircraftBuilt 1993 · S/N 20446 N958TENewman Robert · Groton, NYBuilt 2004 · S/N 10237 N9591BSmith Justin T · Marshfield, WIBuilt 1981 · S/N 172RG0904 N9591CLoera Arnold · Dillingham, AKBuilt 1989 · S/N 1077 N9591JLea Brenda A · Merriam, KSBuilt 1966 · S/N 28-3730 N9591USmolek Michael A · Saint Marys City, MDBuilt 1976 · S/N AA5A-0091 N9592DJohnson Jeremiah W · Tulsa, OKS/N 22-6499 N9592LHausknecht Brian · Corpus Christi, TXBuilt 1974 · S/N AA5-0592 N9592UN9592u LLC · Versailles, KYBuilt 1976 · S/N AA5A-0092 N9592WDreamcatcher Aviation LLC · Austin, TXS/N 28-23040 N9593BBehnke Christopher H · SiegburgBuilt 1981 · S/N 172RG0906 N9593HSaliba Bahig Nadim · Scottsdale, AZBuilt 1975 · S/N 17266252 N9593JPhillips Raymond A Jr · Vestal, NYBuilt 1966 · S/N 28-3732 N9593KShoham Aviation LLC · Richmond, TXBuilt 1976 · S/N 28-7625185 N9593LPeters Larry L · Sheffield, IABuilt 1974 · S/N AA5-0593 N9593VWeaver Robert D · Petersburg, WVBuilt 1974 · S/N 17264395 N9594HEagle Sky Patrol Inc · Deadwood, SDS/N 17266253 N9594JJensen Enterprises LLC · Iola, KSBuilt 1966 · S/N 28-3740 N9594SRuiz Santiago · Jupiter, FLBuilt 1965 · S/N 41 N9594UWilliams Jason R · Drums, PABuilt 1976 · S/N AA5A-0094 N9594WMiddlecoast Air LLC · Grand Rapids, MIBuilt 1967 · S/N 28-23044 N9595DSchlosser Joseph V · Rockford, MNBuilt 1958 · S/N 22-6502 N9595JMuller Chester E · Hayward, CABuilt 1966 · S/N 28-3741 N9595TWorden James L · Tucson, AZBuilt 1989 · S/N 1072 N9595UGrumman Squadron LLC · Prattville, ALBuilt 1976 · S/N AA5A-0095 N95962Forst Richard A · Sitka, AKBuilt 1989 · S/N 1093 N95965Colvin Kurt W · San Luis Obispo, CABuilt 1989 · S/N 1094 N9596DRoss Jack H · Portland, ORBuilt 1958 · S/N 22-6504 N9596HCorby Brenda K · Oak View, CABuilt 1976 · S/N 17266255 N9596JAstraeos Aviation LLC · Salisbury, NCBuilt 1966 · S/N 28-3742 N9596LPriebe John F · Troy, OHBuilt 1974 · S/N AA5-0596 N9596UOlds Jack R DBA · Madison, INBuilt 1976 · S/N AA5A-0096 N9596WFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N 28-23046

Back to AD 80-04-03 R2