Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N6416RNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 28-21595 N6416USt Marie Jack W · Encinitas, CABuilt 1962 · S/N 2163 N64173Training Planes LLC · Tampa, FLBuilt 1975 · S/N 17265065 N64174Sen Air Inc · Mckeesport, PABuilt 1975 · S/N 17265066 N6417JChapman Michael K · North Salt Lake, UTS/N 17273871 N6417RBogey Aviation LLC · Piqua, OHS/N 28-21596 N64180Spanaflight LLC · Puyallup, WABuilt 1975 · S/N 17265069 N64181Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275529 N64184Arlington Flight Services Inc · Arlington, WABuilt 1975 · S/N 17265071 N64186Paraloft LLC · Mims, FLBuilt 1975 · S/N 17265072 N6418DAirways Aviation Inc · Grand Rapids, MNBuilt 1979 · S/N 17272793 N6418ELima-001 LLC · Muscatine, IAS/N 17272019 N64191Flycarolina LLC · Concord, NCBuilt 1975 · S/N 17265076 N64192Skyhawk Transport LLC · Hazel Green, ALBuilt 1975 · S/N 17265077 N64198Randy Goering Inc · Bend, ORBuilt 1975 · S/N 17265080 N64199Mutschler George Robert Jr · Bayfield, COBuilt 1975 · S/N 17265081 N6419JMathis Charles D · Carrollton, GABuilt 1968 · S/N 28-4836 N6419VUrbana Aircraft LLC · Urbana, MDBuilt 1980 · S/N 172RG0680 N641CCClub Cherokee Inc · Crystal, MNBuilt 1978 · S/N 28-7890493 N641DHFisher Russell D · Vacaville, CABuilt 1999 · S/N 23388 N641MAAscent Aviation Inc · Duluth, MNBuilt 2005 · S/N 1400-2005 N641PPhilip Mark A · Leesburg, VABuilt 2004 · S/N 1357-2004 N641PTPapa Tango LLC · West Monroe, LABuilt 1998 · S/N 641 N641RHJakes Guide Service LLC · Willow, AKS/N 18-8388 N64201Registration Pending · Lander, WYRegistration pendingBuilt 1975 · S/N 17265083 N64203Vance Nicholas D · Bluffton, OHS/N 17265084 N64209Kay Roland C · Wasilla, AKS/N 17265090 N6420JPomerenke Tyler J · Fairmont, MNBuilt 1968 · S/N 28-4837 N6420ULambert Glen C · Las Vegas, NVBuilt 1962 · S/N 2250 N6420VKorson James · Yorkville, ILBuilt 1980 · S/N 172RG0681 N64213Ajc Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 17265093 N64215Registered aircraftBuilt 1975 · S/N 17265095 N64217Simplifly LLC · Mesa, AZBuilt 1975 · S/N 17265097 N64219American Patrols Inc · Midland, TXBuilt 1975 · S/N 17265098 N6421JShoemaker Kent L · Renfrew, PABuilt 1968 · S/N 28-4839 N6421UAlpha 1 Aviation LLC · Helena, ALBuilt 1962 · S/N 2168 N6421WTyde Arthur F III · Los Angeles, CAS/N 28-20491 N64220Wieman Dianne L · Marion, TXBuilt 1975 · S/N 17265099 N64224Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 17265103 N64228Abbott Cedric M · Buckfield, MEBuilt 1975 · S/N 17265105 N6422JSuncoast Aviators LLC · Odessa, FLBuilt 1968 · S/N 28-4840 N6422RYang Chi · Lafayette, COBuilt 1966 · S/N 28-21601 N6422WDomler Michael R · Gilroy, CABuilt 1964 · S/N 28-20492 N64231Driessen James A Jr · Oshkosh, WIBuilt 1982 · S/N 17275538 N64232Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1975 · S/N 17265108 N64233Walla Walla University · College Place, WABuilt 1975 · S/N 17265109 N64235Skyhawk Flying Club · Marysville, OHBuilt 1975 · S/N 17265110 N64236Wright Chris E · Houghton Lake, MIBuilt 1975 · S/N 17265111 N64238Global Adventures N64238 LLC · Hollywood, FLBuilt 1975 · S/N 17265112 N6423RBerkner Charles P · Milbank, SDBuilt 1966 · S/N 28-21602

Back to AD 79-10-03 R2