Skip to content

Registered aircraft · 20,481

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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N9901BNichols Patrick C · Fairview, NCBuilt 1957 · S/N 34301 N9901EBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18263961 N9901NTeets David J · Fairbanks, AKBuilt 1975 · S/N 18052556 N9901VMinske Troy · Princeton, MNBuilt 1966 · S/N 18051753 N9902EOtto Real Estate Investment Inc · Bakersfield, CABuilt 1975 · S/N 18263962 N9902VEuroaviation Inc Trustee · KematenBuilt 1966 · S/N 18051754 N9903MRegistered aircraftBuilt 1976 · S/N 18264799 N9903TRiddle John G · Townsend, MTBuilt 1960 · S/N 53003 N9904HWingin It LLC · Marshall, MNBuilt 1981 · S/N 18268101 N9905ELf Flying LLC · Wellington, MOBuilt 1985 · S/N 18268469 N9905HWhitaker Billy Dean Jr · Houston, TXBuilt 1981 · S/N 18268102 N9906MWhorton Darren · Nashville, TNBuilt 1976 · S/N 18264802 N9906VStruempler Jed E · Anchorage, AKBuilt 1966 · S/N 18051758 N9907BMalone Parachute Club Inc · Williston, VTBuilt 1957 · S/N 34307 N9907CBlue Marlin LLC · Kalispell, MTBuilt 1978 · S/N R18200488 N9907HMather Aviation LLC · Mather, CABuilt 1981 · S/N 18268103 N9908EAndrews Allen P · Longview, TXBuilt 1975 · S/N 18263968 N9909NMorgan Vernon E · Dillon, COS/N 21063250 N9909XMameli Tyler L · Williamson, GABuilt 1961 · S/N 185-0109 N9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKBuilt 1983 · S/N U20606740 N990CKSaucier Christopher A · Marion, MTBuilt 1976 · S/N 18265006 N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690 N990VPValenzuela Pedro · Douglas, AZBuilt 1979 · S/N U206-04673 N990WPThomas Field Flying Club LLC · Holly Springs, MSBuilt 1973 · S/N 18262238 N9910ESmoke Eagles Inc · Newport Beach, CABuilt 1975 · S/N 18263970 N9910MSatran Paul C · Detroit Lakes, MNBuilt 1977 · S/N 21062089 N9910XHower Loyal L · Moscow, IDBuilt 1961 · S/N 185-0110 N9911BGustafson Kim · Lake Stevens, WABuilt 1957 · S/N 34311 N9911HDouglas Forest Protective Association · Roseburg, ORBuilt 1981 · S/N 18268107 N9911VInternational Air Services Inc Trustee · Carson City, NVS/N 18051763 N9911XDesolation Aviation LLC · Fort Worth, TXBuilt 1961 · S/N 185-0111 N9912NRegistered aircraftBuilt 1975 · S/N 18052567 N9913EHobot LLC · Springdale, ARBuilt 1975 · S/N 18263973 N9913MVillapudua Ruben Ruiz · Phoenix, AZBuilt 1977 · S/N 21062090 N9913VIsern Douglas J · Golden, COBuilt 1966 · S/N 18051765 N9914MLabra Victor David · Mesa, AZS/N 18264810 N9914VJennair LLC · Wilmington, DEBuilt 1966 · S/N 18051766 N9915HTj Aero LLC · Valencia, CABuilt 1981 · S/N 18268109 N9915MBoone John G · Goleta, CABuilt 1976 · S/N 18264811 N9915NKackley Floyd L · Grand Rapids, MNBuilt 1975 · S/N 18052570 N9916Addison William S · Colorado Springs, COBuilt 1955 · S/N 31413 N9916ESchult Jessica Elaine · Boise, IDBuilt 1975 · S/N 18263976 N9916HSky Blue Adventures LLC · Boulder, COBuilt 1981 · S/N 18268110 N9916ZWings Of Wisconsin LLC · New Richmond, WIS/N U20606744 N9917BVisscher Ty · Santa Rosa, CABuilt 1957 · S/N 34317 N9917ESopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1975 · S/N 18263977 N9917NThunderbird LLC · Tacoma, WABuilt 1975 · S/N 18052572 N9918NCalef Jere R Trustee · Mojave, CABuilt 1975 · S/N 18052573 N9918VGray Paul W · Eads, TNBuilt 1966 · S/N 18051770 N9919EN9919e LLC · Rio Vista, TXBuilt 1975 · S/N 18263979

Back to AD 84-10-01 R1