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.

N6066JTouchett Air Inc · Long Lake, WIS/N 18263621 N6067FPitts Ryan · Brewton, ALBuilt 1975 · S/N 18264083 N6068FStamp Michael R · Crescent City, FLBuilt 1975 · S/N 18264084 N6068JNoble Aviation Enterprises LLC · Phoenix, AZBuilt 1975 · S/N 18263622 N6069BPlane Jane Inc · Berlin, MDBuilt 1957 · S/N 34069 N606TLK C Enterprises Of Basile · Basile, LAS/N 21060545 N606TXF-22 LLC · Danbury, TXBuilt 1978 · S/N 18266763 N6070BLongley Tracy C · Stephenville, TXBuilt 1957 · S/N 34070 N6070FKaufman Robert L · Clarksville, TNBuilt 1975 · S/N 18264086 N6070JA Tumbling T Ranches · Goodyear, AZBuilt 1975 · S/N 18263624 N60710Johnson Douglas D · Sacred Heart, MNBuilt 1976 · S/N 18052777 N6071FTweedy Daniel G · Nampa, IDBuilt 1975 · S/N 18264087 N6071NJames Selle Aviation LLC · Bonesteel, SDBuilt 2006 · S/N 18281844 N6072BTrico Mechanical Company Inc · La Fayette, GABuilt 1957 · S/N 34072 N6074BYount Lawrence F · Shelton, WABuilt 1957 · S/N 34074 N6075FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 18264090 N60766Congdon Douglas J · Fairbanks, AKBuilt 1973 · S/N U20602044 N60768Mcgee Jacob Quinton · Anchorage, AKS/N U20602045 N6076BBouchard Timothy · Valdez, AKBuilt 1957 · S/N 34076 N6076FCancro J Chriss · Enumclaw, WABuilt 1975 · S/N 18264091 N6077JLove To Fly LLC · Myrtle Beach, SCBuilt 1975 · S/N 18263627 N6078CKtoa Rentals LLC · Torrance, CABuilt 1978 · S/N R18200370 N6079BRift LLC · Union, MOBuilt 1957 · S/N 34079 N6079CAllen William H Trustee · Big Bear City, CAS/N R18200371 N6079F6079 Foxtrot Inc · Dover, DES/N 18264094 N607MLIprop LLC · Palm Beach Gardens, FLBuilt 2006 · S/N 18281849 N60809Van Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 18282063 N6080FKonecny Walter O · Draper, UTS/N 18264095 N6081CShannon Jeanette M · Marathon, FLS/N R18200372 N6083BListo Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1978 · S/N 21062677 N6083FConservation Services LLC · Sheridan, WYBuilt 1975 · S/N 18264098 N6084BCenturion Aviation Ltd · Salina, KSBuilt 1978 · S/N 21062678 N6086JSiegel Quarry LLC · Versailles, MOBuilt 1975 · S/N 18263628 N6086SDos Lobos Aviation LLC · Yankton, SDBuilt 1980 · S/N R18201610 N6087BAzure Farms Inc · Dufur, ORBuilt 1957 · S/N 34087 N6087FKozub Matthew P · Exeter, RIBuilt 1975 · S/N 18264102 N6088ERacoon Aviation LLC · San Antonio, TXS/N 18268343 N6088JCummings David · Grand Junction, COS/N 18263629 N6089BValentine Terence S · Glennallen, AKBuilt 1957 · S/N 34089 N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261 N608FGWilliam J Taylor Aviation LLC · Kendallville, INBuilt 1979 · S/N 18266913 N608LDWeldon Robert S · Tallahassee, FLBuilt 1958 · S/N 50206 N608SHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282198 N6091BMcmurry Andrew Clinton · Sandy Hook, MSBuilt 1957 · S/N 34091 N6092BKeenan Michael John Trustee · Anchorage, AKBuilt 1957 · S/N 34092 N6093FLrh Equipment LLC · Pendleton, ORBuilt 1975 · S/N 18264108 N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681 N6095FPlane Partners LLC · Navarre, FLBuilt 1975 · S/N 18264110 N6097BBenavidez Robert · Deming, NMBuilt 1957 · S/N 34097 N6098AMcknight Christopher M · Nampa, IDBuilt 1957 · S/N 180-32943

Back to AD 84-10-01 R1