Skip to content

Registered aircraft · 40,472

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.

N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036 N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035 N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353 N321DFFranklin David A · Sealy, TXBuilt 2001 · S/N 570E N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236 N321DRSavakinas Alan M · Clarence, NYBuilt 1979 · S/N 28-8090011 N321EFRengel Richard J · Tustin, CAS/N 1900 N321ESQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N AA5A-0729 N321GDFirst Light Inc · Lafayette, LABuilt 1977 · S/N AA5B0461 N321GTBennett Craig · Newbury Park, CABuilt 1994 · S/N 21158 N321JBCox Kevin · Lexington, KYBuilt 1978 · S/N AA5A0560 N321KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1982 · S/N 17275853 N321MJPetrie David W · Mechanicville, NYBuilt 1976 · S/N M-1850 N321MPAker Carroll Gregory · Titusville, FLBuilt 1991 · S/N 10084 N321NASanchez David A · San Luis Obispo, CABuilt 2001 · S/N 24650 N321PAFosston Flying Club Inc · Fosston, MNBuilt 1971 · S/N 17260202 N321PKYaqunda Yousif N · Fallbrook, CABuilt 1994 · S/N PK-1 N321RVRegistration Pending · Norton Shores, MIRegistration pendingBuilt 1998 · S/N 20372 N321SASedlak Julien · Fort Worth, TXBuilt 1993 · S/N 1251 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N321TJCole Warren G · Watkinsville, GABuilt 1976 · S/N 17266807 N321VBYoung Mike · Loop, TXBuilt 1960 · S/N 18-7533 N321VTWinick Scott · Jay, VTBuilt 1973 · S/N 507 N321WSWrong Brothers Aviation LLC · Wilmington, DEBuilt 1973 · S/N AA5-0327 N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036 N32204Flying Country Club Inc · Coal Valley, ILBuilt 1974 · S/N 28-7515094 N32206Williams Jonathan · Meadow, TXBuilt 1974 · S/N 28-7515097 N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037 N32223Boehm William Dean · Baldwin, ILS/N 28-7515101 N32228Segalla Susan B Trustee · Venice, FLBuilt 1974 · S/N 28-7505040 N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163 N3223PPrestige Tech Consulting Inc · Carrollton, TXS/N 1181 N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541 N32245Johnson Donald D · Scottsdale, AZBuilt 1974 · S/N 28-7515102 N3224ZBagley Sherell G · Suwanee, GABuilt 1959 · S/N 22-7168 N32251Kful Flyers Foudation Inc · Fullerton, CAS/N 28-7515104 N32255Registered aircraftBuilt 1974 · S/N 28-7505041 N32256Hasek Christopher A · Plano, TXBuilt 1974 · S/N 28-7505042 N32258Wing Rentals LLC · Phoenix, AZBuilt 1974 · S/N 28-7505043 N32265Norsesian Brandon · Valrico, FLBuilt 1974 · S/N 28-7525040 N32267Top Flight Aviation LLC · Reedsburg, WIBuilt 1974 · S/N 28-7515105 N32269Parker Air LLC · Mobile, ALBuilt 1974 · S/N 28-7515106 N3226NDeuel Justin R · Mankato, MNS/N 243 N32271Tylka Edward · Lockport, ILBuilt 1974 · S/N 28-7505044 N32274Simaan Daniel · Fontana, CABuilt 1974 · S/N 28-7525042 N32276Price Company · Spokane, WABuilt 1974 · S/N 28-7515109 N3227E3227e LLC · Jacksonville, FLBuilt 1978 · S/N 17271475 N3227MParker Shon T · Wasilla, AKBuilt 1947 · S/N 12-2108 N3227PTucker Patricia A · Hamilton, MTBuilt 1957 · S/N 23-1114 N32288Habzansky Michael E · Greens Fork, INBuilt 1974 · S/N 287515112

Back to AD 80-04-03 R2