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.

N84278Ap Air LLC · Wilmington, NCBuilt 1969 · S/N 17258405 N8427DEastin Toby M · Jefferson City, MOS/N 22-5682 N8427GWarrior II Ltd · Des Plaines, ILBuilt 1981 · S/N 28-8116297 N8427KInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116299 N8427RLopez Trinidad V · El Cajon, CAS/N 28-22305 N8427TPierce Rex G · Shorewood, ILBuilt 1981 · S/N 28-8190302 N8427WKsiezyk Donald G · Wadsworth, OHBuilt 1981 · S/N 28-8290030 N84289Angelov Ruslan P · Mount Prospect, ILS/N 17258410 N8428BHiggins James · Oxford, NCBuilt 1981 · S/N 28-8190304 N8428DMullen Samuel J · Fairbanks, AKBuilt 1957 · S/N 22-5683 N8428HWilson Jessica D · Gallipolis Ferry, WVBuilt 1981 · S/N 28-8190305 N8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1981 · S/N 28-8190307 N8428WAces High Aviation LLC · Casper, WYBuilt 1965 · S/N 28-2656 N84293Nwa Flyers LLC · Missoula, MTBuilt 1969 · S/N 17258411 N84299Phoenix Aviation Holdings LLC · Crystal Beach, FLS/N 17258413 N8429DDickson Wayne K · Luthersville, GABuilt 1957 · S/N 22-5684 N8429WCleveland Tommy E · Mountain View, ARBuilt 1965 · S/N 28-2659 N842BJMaster Trade LLC · Detroit, MIBuilt 1977 · S/N 28-7716252 N842LBBlair Lynward E · Headland, ALBuilt 1976 · S/N 252-76 N842PTTemple Peter L · Harrisville, NHBuilt 2022 · S/N 67P N842RBLowcountry Flight LLC · Johns Island, SCBuilt 1969 · S/N 17258377 N842SHSilver Star Helicopters LLC · El Campo, TXBuilt 2005 · S/N 3819 N842SVPylon Aviation Services LLC · Chandler, AZBuilt 1983 · S/N 0366 N842TAkin Air LLC · Monticello, ARBuilt 1960 · S/N TD-355 N84309Mcgee David · West Monroe, LABuilt 1969 · S/N 17258417 N8430DBottorff Marshall B · Kimberling City, MOBuilt 1957 · S/N 22-5685 N8430RRegistration Pending · Calera, OKRegistration pendingBuilt 1966 · S/N 28-22309 N8430WZuber Thomas P · Opelika, ALBuilt 1965 · S/N 28-2660 N84316Smith Jimmy C · Plano, TXBuilt 1969 · S/N 17258419 N84317Waco West Inc · Dover, DEBuilt 1969 · S/N 17258420 N8431LDsr Cherokee 180 LLC · Dallas, TXS/N 17256631 N8431WAhearn Bernard Francis · Farmington, NHS/N 28-2661 N84326Yang Edward E · Killeen, TXBuilt 1981 · S/N 28-8116313 N8432CEmpire Aviation · Oxford, NCBuilt 1976 · S/N 28-7625117 N8432LAster Labs Inc · Shoreview, MNBuilt 1968 · S/N 17256632 N8432WBinek Darwin P · Midlothian, TXBuilt 1965 · S/N 28-2662 N84330Blanche-Caron Elie P · Palmer, AKBuilt 1969 · S/N 17258421 N84332Engler Jerry J · Kerrville, TXBuilt 1969 · S/N 17258422 N84333Backup Enterprises LLC · Conway Springs, KSBuilt 1969 · S/N 17258423 N84338Jrh Wings LLC · Alva, OKS/N 17258426 N84339Burnt Pond Aero LLC · Ostrander, OHBuilt 1969 · S/N 17258427 N8433LHeacock Jeffrey A · Hollis, MEBuilt 1968 · S/N 17256633 N8433RRichards Riley · Seattle, WABuilt 1966 · S/N 28-22313 N8433WKilduff James L · Wellsboro, PABuilt 1965 · S/N 28-2663 N84342Choate Aviation LLC · Summerville, SCBuilt 1969 · S/N 17258429 N84346Registration Pending · New Derry, PARegistration pendingS/N 17258433 N84347Giovannini Marco · Malibu, CABuilt 1969 · S/N 17258434 N8434DAllen Clifford R · Indianapolis, INBuilt 1957 · S/N 22-5689 N8434LMemmi Charles D · Three Springs, PABuilt 1968 · S/N 17256634 N8434RPeoples John R Jr · Hixson, TNS/N 28-22314

Back to AD 80-04-03 R2