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.

N798SMPointer Logistics LLC · Rancho Cucamonga, CABuilt 1998 · S/N 18280266 N7990VSutton Aircraft Salvage LLC · Palmer, AKS/N 18051890 N79927Tiger Field Aviation LLC · Lake Butler, FLS/N 18261846 N79933Ajr Rentals LLC · Mulino, ORBuilt 1973 · S/N 18261847 N79958Gilbert Paul Russell · Dothan, ALBuilt 1973 · S/N 18261850 N799ACYeates Jeffrey B · Battle Ground, WAS/N U20605827 N799BSBlue Sky Aviation LLC · Clarksburg, MDBuilt 1979 · S/N 18267293 N799HLNevison Shane · Lebanon, MEBuilt 1974 · S/N 18262733 N799HPBristol Bay Air Service Inc · Dillingham, AKS/N 18268575 N799JLackemann Thomas E · Sayville, NYBuilt 1998 · S/N 18280133 N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580 N799PCRegistration Pending · Colorado Springs, CORegistration pendingBuilt 1966 · S/N T210-0178 N79AGarg Christopher D · Shoreline, WABuilt 1953 · S/N 30079 N79BBRegistration Pending · Wilmington, DERegistration pendingBuilt 1965 · S/N 18256797 N79CDMcvay E Howard Jr · Riverside, RIBuilt 1979 · S/N 18266793 N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615 N79GSUavionix Corp · Bigfork, MTBuilt 1962 · S/N 18254441 N79JPErickson James · Wasilla, AKBuilt 1979 · S/N 18267081 N79MPMissouri State Highway Patrol · Jefferson City, MOBuilt 2001 · S/N 18281003 N79NHSchmidt Aviation Inc · Boring, ORBuilt 1982 · S/N 18268168 N79PCRuskin Keith Jonathan · Chapel Hill, NCBuilt 2018 · S/N 18283047 N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697 N79SLCade David M · Asheville, NCBuilt 1979 · S/N 18053065 N79STAllevato Eugenio · Northridge, CABuilt 1978 · S/N R18200222 N79TCBear Cat Air LLC · Gun Barrel City, TXBuilt 1974 · S/N 18052479 N79THHudson Thomas · Bessemer, ALBuilt 1964 · S/N 21058329 N79TRWallace Ronald J · Santa Teresa, NMBuilt 1979 · S/N 18267136 N79VK3g'S Aviation LLC · St Simons Island, GABuilt 1979 · S/N 21063322 N79WGSmith Ryan · Leawood, KSBuilt 1980 · S/N 182-67585 N79WWWindward Aviation Inc · Puunene, HIBuilt 2000 · S/N 20608129 N7ALFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21063261 N7AMGalluzzi Michael C · Edgewater, FLBuilt 1999 · S/N 18280497 N7BVHartman Gregory S · San Mateo, CAS/N R18200432 N7CEGerhardstein Gregory V · Friday Harbor, WABuilt 1999 · S/N 20608030 N7CTDenney Michael J · South Lake Tahoe, CABuilt 1965 · S/N 18051616 N7DLWubben Robert · Waupaca, WIBuilt 1969 · S/N 18259774 N7HRCessna 182p N7hr LLC · Homer, AKBuilt 1975 · S/N 18264253 N7JZR & R Vehicles LLC · Davie, FLBuilt 1977 · S/N 21062116 N7LBLiberty University Aviation Dept · Lynchburg, VABuilt 1959 · S/N 52057 N7LTRobertson Cameron Lee · Las Vegas, NVS/N 21060936 N7MLPuchner Christopher C · Ester, AKBuilt 1973 · S/N 18052296 N7RABeck James E · Palacios, TXBuilt 1979 · S/N 18266880 N7RDSchipper Properties Inc · San Jose, CABuilt 1967 · S/N 21058847 N7REMid Tex Controls Inc · Krum, TXBuilt 1975 · S/N 18264434 N7RRTavan Richard M · Saratoga, CAS/N 21063468 N7RVHartzell Joseph J · GrandvauxBuilt 1979 · S/N 18267435 N7RWNelson Jeffrey S · Darby, MTBuilt 1956 · S/N 34012 N7TTWright Gregory B DBA · Amarillo, TXBuilt 1973 · S/N 18262408 N7UBWhite James V · Prescott, AZBuilt 1976 · S/N 21061593 N7YXOc Aviators LLC · Troy, TNBuilt 1976 · S/N 18264894

Back to AD 84-10-01 R1