Skip to content

Registered aircraft · 6,348

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.

N34212Daniel Brian J · Volcano, HIS/N 915B2 N342PTParker Matthew M · Mesa, AZBuilt 1999 · S/N 101742 N3433MDixon Tom N · Lodi, CABuilt 1947 · S/N 12-2270 N3435MJanson Matthew G · Midland, MIBuilt 1947 · S/N 12-2273 N3438MClark Stanley E Trustee · Redmond, ORBuilt 1947 · S/N 12-2276 N3439MRetzlaff Chris · Ripon, WIBuilt 1947 · S/N 12-2279 N343LMMast Henry V · Dayton, TXBuilt 1992 · S/N 01990 N343RLGilbert Jackie Wayne Sr · Monroe, LABuilt 2002 · S/N 70 N343TMonroe Robert E · Navarre, FLBuilt 1997 · S/N 001 N3440MNaples Seaplane Adventures LLC · Denmark, MES/N 12-2287 N3447MRegistration Pending · Marstons Mills, MARegistration pendingBuilt 1947 · S/N 12-2065 N3448MCannell Kirby B · Salome, AZBuilt 1947 · S/N 12-2344 N344RDSchab-Davis Margaret A · Spangle, WABuilt 2003 · S/N 02-PA18AB N344WBeck Tom E · Homer, AKBuilt 1946 · S/N 12-775 N3451MWilliamson Gary T · Ashmore, ILBuilt 1947 · S/N 12-2342 N3453MSmith Matthew M · Anchorage, AKBuilt 1947 · S/N 12-2340 N3455MHall II Darryl Wayne · Wasilla, AKS/N 12-2324 N3461MGrass Brian Shane · Ocala, FLBuilt 1947 · S/N 12-2316 N34621Sutton Bradley V · Dallas, TXBuilt 1941 · S/N 8021 N3466MLutes Ralph E · Shipshewana, INBuilt 1947 · S/N 12-1900 N3469MHoogeveen Douglas F · Clifton, COBuilt 1947 · S/N 12-2347 N3470MThoensen Thomas R · Delta, COBuilt 1947 · S/N 12-2348 N3473Richmond Randy W · Roanoke, TXBuilt 2022 · S/N 001 N34730Ivy James H III · Seligman, AZBuilt 1941 · S/N 1543 N3473MDavis Glenn A · Fair Oaks, CABuilt 1947 · S/N 12-2335 N347ACHarkal Enterprises · Des Moines, IABuilt 1998 · S/N 1371-98 N3480MMegli Mike O · Dillingham, AKBuilt 1947 · S/N 12-2326 N3483MHopwood Andrew R · Elbert, COBuilt 1947 · S/N 12-2339 N34841Buehler Benjamin · Eagle River, WIBuilt 1945 · S/N 5 N3487MSchroeder Kenneth M Jr · Pinehurst, NCBuilt 1955 · S/N 12-2331 N3492MSchumacher Peter M · Buffalo, WYBuilt 1947 · S/N 12-2336 N3493MChristian Peter A · Eagle River, AKS/N 12-2337 N3496MBell Russell P · Auburn, NYBuilt 1947 · S/N 12-2081 N3497MGebhart Travis D · Meadow, SDBuilt 1947 · S/N 12-2355 N3498MSeavoy Roger J · Mc Grath, AKBuilt 1947 · S/N 12-2087 N349BBozell Jerry L · Plainfield, INFirst renewal noticeBuilt 1981 · S/N 161 N34JRJohnson Roger C · Lake Havasu City, AZBuilt 1983 · S/N 174 N34WAMelby Mark G · Racine, WIBuilt 1978 · S/N 1-B N34WLSeaquist Gregory C · Oneida, WIBuilt 1975 · S/N AA1B-0522 N34ZAJoiner Marshall C · Concord, NCBuilt 1997 · S/N 200034 N3500NMurray Kevin D · Moneta, VABuilt 1947 · S/N 22728 N350JKLawrence Steven R · Chowchilla, CABuilt 1982 · S/N 350 N350SQGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285152 N3511MBlack Spruce Aviation LLC · Hermon, MEBuilt 1947 · S/N 12-2093 N3512KEarlys Cycle Center Inc · Harrisonburg, VABuilt 1946 · S/N 22203 N3512MSutton Aircraft Salvage LLC · Palmer, AKS/N 12-2664 N3517MWilder Kirk E · Boonville, CABuilt 1947 · S/N 12-2384 N3524MMontmorency Enterprises LLC · Atlanta, MIBuilt 1947 · S/N 12-2370 N3527MMisinco Michael H · Macon, GABuilt 1947 · S/N 12-2371 N3531MBorder James H · Weiser, IDBuilt 1947 · S/N 12-2375

Back to AD 80-25-02 R2