Skip to content

Registered aircraft · 6,349

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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N47791Schwartz John E · Ventura, CABuilt 1979 · S/N 15283250 N477UCWeber Jennifer R · Bryan, TXBuilt 2013 · S/N 001 N47808Colgan Aviation LLC · La Crosse, WIBuilt 1979 · S/N 15283253 N4781ZM Forden LLC · Pana, ILBuilt 1961 · S/N 22-8343 N4784AFox Aviation International Inc · Justin, TXBuilt 1979 · S/N A1520891 N4784HKjeldgaard James K · Fremont, NEBuilt 1948 · S/N 11-737 N47856Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283258 N4785BBravo Zulu Aviation LLC · Torrance, CAS/N 15283633 N4785ZMeigs David C · Phoenix, AZS/N 22-8349 N4786PAce High Aviation LLC · Long Beach, CAS/N 15284816 N4787ZIdaho Airplanes LLC · Boise, IDS/N 22-8351 N478BKWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15281022 N478RBBrown James L · Soddy Daisy, TNS/N 478 N4791QSelzer Robert S · Anchorage, AKBuilt 1981 · S/N 15285063 N47930Nextgen Flight Academy Inc · Riverside, CAS/N 15283263 N4795MMountain Air Inc · Quincy, CAFirst renewal noticeBuilt 1997 · S/N 11308 N4798ZAnderson David J · Fridley, MNBuilt 1961 · S/N 22-8365 N4799ANew England Aircraft Detailing LLC · Webster, MABuilt 1979 · S/N A1520893 N4799ZRegistration Pending · Carefree, AZRegistration pendingBuilt 1961 · S/N 22-8366 N47FSDahl Duane A · Glasgow, MTS/N 11-102 N4800MDunn Bernard P · Carson City, NVBuilt 1980 · S/N 15284484 N4800ZGorzynski Dustin B · Great Falls, MTBuilt 1961 · S/N 22-8367 N4801ZButler Delbert C · Caldwell, IDS/N 22-8368 N48024Aftcloud Inc · Ontario, CABuilt 1979 · S/N 15283270 N48033Franconi Michael J · Newington, CTBuilt 1979 · S/N 15283271 N4803JWhite Jack D · Orangevale, CABuilt 2012 · S/N S94120077 N4803ZBuffalo Flyers LLC · Buffalo, MOBuilt 1961 · S/N 22-8370 N48042Simmons Kenton L · Van Alstyne, TXBuilt 1979 · S/N 15283273 N48056Little Duke Aviation LLC · Saint Paul, MNBuilt 1979 · S/N 15283276 N4805ZWittman Kristofer L · Anchorage, AKS/N 22-8372 N48068Ikarus Aviation LLC · Salt Lake City, UTBuilt 1979 · S/N 15283277 N4806BMckinney Brett A · Hackleburg, ALBuilt 1979 · S/N 15283647 N4807BSun Aircraft Management LLC · Ormond Beach, FLBuilt 1979 · S/N 15283648 N4807GAdnd LLC · New Ipswich, NHBuilt 1979 · S/N 17273355 N4810ZMussell Logan Michael · Leslie, MIBuilt 1961 · S/N 22-8379 N4811ZClark Ronald L · Marysville, WABuilt 1961 · S/N 22-8380 N4813ZStanley Daniel P · Kiowa, KSS/N 22-8383 N48156Perdue Ralph R Jr · Blacklick, OHBuilt 1979 · S/N 15283291 N4815ZRoberson James · Stephenville, TXS/N 22-8385 N48167American Aviation Inc · Brooksville, FLBuilt 1979 · S/N 15283293 N4817BPriority One Insurance & Investments Inc · Hillsboro, NDBuilt 1979 · S/N 15283653 N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311 N4818ZCornell Robert C · Lock Haven, PABuilt 1961 · S/N 22-8389 N4819BSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283654 N4819ZWest Coast Air Design LLC · Granada Hills, CAS/N 22-8390 N48204Young Achilles Hsi-Jung · La Habra, CABuilt 1979 · S/N 15283301 N4820ZPumford Thomas E Jr · Bannister, MIBuilt 1961 · S/N 22-8391 N48222N1705r Inc · Cobb, CAS/N 15283303 N48228M & L Utility Contractors Inc · Cottondale, FLBuilt 1979 · S/N 15283304 N48238Hamilton Brandon T · Morehead, KYBuilt 1979 · S/N 15283306

Back to AD 80-25-02 R2