Skip to content

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.

N975ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916121 N975BSSaurdiff Benjerman D · Two Rivers, AKBuilt 1979 · S/N 302-79 N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718 N975DGPhillips Duke · Hyattville, WYBuilt 2000 · S/N 2112 N975LEBlue Borracho LLC · Manitou Springs, COBuilt 1975 · S/N 28-7690001 N975LLWoodhouse William H · Power, MTS/N 975 N975SGage Christopher R · Truckee, CABuilt 1999 · S/N 1263-99 N976Green Alexander · Germantown, TNBuilt 1985 · S/N 673 N9760CStreet Steven J · Rochester, MIBuilt 1978 · S/N 28-7816526 N9760DDavis Michael P · Midway, UTBuilt 1959 · S/N 22-6675 N9760JHanks Cathy J · Danville, KYBuilt 1967 · S/N 28-3953 N9760MNeal Alan B · Cherry Valley, CABuilt 1967 · S/N 670054 N9760UFitzgerald John P · Pittsburgh, PABuilt 1976 · S/N AA5A-0160 N9760WRegistered aircraftBuilt 1967 · S/N 28-23244 N9761PBig Q Aviation Corporation · Helena, MTBuilt 1975 · S/N 18-7609025 N9761WRivera-Osorio Karolina · Monroe, NYS/N 28-23245 N9762DMarshall Marcus D · Georgetown, TXBuilt 1959 · S/N 22-6677 N9763JShaffer Timothy R · Marion, IABuilt 1967 · S/N 28-3958 N9763MWaldren Paden · Garden Valley, CABuilt 1967 · S/N 670057 N9764MSilcott Robert W III · Fairview, OKBuilt 1967 · S/N 670058 N9764WMich John D · Fort Morgan, COBuilt 1967 · S/N 28-23250 N97650Updraft LLC · Kissimmee, FLS/N 17276218 N9765DPatey Daniel J · Lakewood, CABuilt 1959 · S/N 22-6680 N9765JPinson Cassandra · Chandler, AZBuilt 1967 · S/N 28-3960 N9765LMartone Aviation LLC · Ocala, FLBuilt 1972 · S/N M-1383 N9765MMahoney James P · Renton, WABuilt 1967 · S/N 670059 N9765WShelby Gary J · Harleysville, PABuilt 1967 · S/N 28-23251 N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219 N9766DMayer Gregory B · Fall River Mills, CABuilt 1959 · S/N 22-6682 N9766WYoung Justice P · Prairie Grove, ARS/N 28-23252 N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220 N9767JMatta Aviation Services LLC · Junction City, KSBuilt 1967 · S/N 28-3963 N9767MMcgill James D · Tucson, AZBuilt 1967 · S/N 670061 N9767WBrighton Flying Club LLC · Brighton, MIBuilt 1967 · S/N 28-23254 N97681Buiqui Aerospace Corp · Kissimmee, FLBuilt 1984 · S/N 17276221 N9768JOpp Prop Air LLC · Collierville, TNBuilt 1967 · S/N 28-3964 N9768WEichner Cynthia A Loening · Tolland, CTBuilt 1967 · S/N 28-23255 N9769JDubovtsev Mikhail · Wildwood, NJBuilt 1967 · S/N 28-3967 N976ACNaples Air Center Inc · Naples, FLBuilt 1981 · S/N 28-8116308 N976DPKnox John R · Arvada, COBuilt 1998 · S/N 23808 N976MAZephyr Ventures Inc · Wilmington, DEBuilt 1976 · S/N 13043 N976MSStaten Joseph A · Kitty Hawk, NCBuilt 1976 · S/N AA5B0353 N97702Smith Jeffrey W · Yakima, WABuilt 1984 · S/N 17276222 N9770UPlegge Timothy E · Granbury, TXBuilt 1976 · S/N AA5A-0170 N9770WRegistration Pending · Altus, OKRegistration pendingBuilt 1967 · S/N 28-23257 N9771DHull Christian M · Palmer, AKBuilt 1959 · S/N 18-6830 N9771JBuzzard Roost Aviation LLC · Marble, NCBuilt 1967 · S/N 28-4009 N9771LLarson Steven E · Columbus, NEBuilt 1972 · S/N M-1402 N9771QAerospec Insurance LLC · Gig Harbor, WAS/N 1254 N9772WCow Dog Flyers LLC · Bozeman, MTBuilt 1967 · S/N 28-23259

Back to AD 80-04-03 R2