Registered aircraft · 40,394

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.

N86625Ready Aim Flyer LLC · New Castle, DEBuilt 1973 · S/N 646-74 N86633Gregor John E · Fairbanks, AKS/N 682-74 N86636Olson Kenneth L · Raymond, WABuilt 1973 · S/N 648-74 N8663DLawrence Alexander · Miamisburg, OHBuilt 1958 · S/N 22-5871 N8664Page Jason · Medina, TNBuilt 1973 · S/N 463-73 N86647Reuhl Kenneth R · Piscataway, NJS/N 295-74 N8664CArcher 64c LLC · Essex, MABuilt 1976 · S/N 28-7690156 N8664DWyant David Mark · Dallas, TXBuilt 1958 · S/N 22-5872 N8664VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 169-75 N8664YWard Nelson Harley · Salcha, AKBuilt 1970 · S/N 18-8895 N8666KBuce Thomas M · Kimberly, ORS/N 108-1666 N8667VBloomquist Ronald D · Mooresburg, TNBuilt 1975 · S/N 17075 N866MAGoose Aviation Co · Wilmington, DEBuilt 1974 · S/N 28-7415455 N866MMMorris Engineering Group LLC · Juneau, AKBuilt 2005 · S/N CC18-0003 N866RHMerrill D J · Topsham, MEBuilt 1999 · S/N 5288 N866TSSteier Tim A · Blue Earth, MNBuilt 2010 · S/N 18-002 N8670CReabe Damon P · Ripon, WIBuilt 1953 · S/N 18-2814 N8670EMarvin Carlton R · Tomahawk, WIBuilt 1968 · S/N A1 N86711Crane David D · Cadott, WIBuilt 1974 · S/N 654-74 N86713Tuckerman Flying Service Inc · Tuckerman, ARBuilt 1974 · S/N 681-74 N86714Odonnell Daniel V · Dover, DEBuilt 1974 · S/N 10-74 N86726Sale Reported · Mesa, AZSale reportedBuilt 1946 · S/N 1087 N8672DPlate Ronald L · Soldotna, AKS/N 18-6273 N8672EMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7615147 N8672VHarris Kenneth L · Greeley, COBuilt 1975 · S/N 174-75 N86738Myran Kenneth · Taylor, NDBuilt 1974 · S/N 657-74 N8674VIberlin Ranch · Gillette, WYBuilt 1975 · S/N 826-75 N86752J&M Aviation Supply Inc · Shreveport, LABuilt 1974 · S/N 292-74 N8675EBarbarich Allen G · Las Vegas, NVBuilt 1976 · S/N 28-7690186 N8675RMeyer Jason P · Tempe, AZBuilt 1999 · S/N 21554 N86768Tarver Dalton K · Fallon, NVBuilt 1946 · S/N 1129 N8677VAlbij3 LLC · Milton, FLBuilt 1975 · S/N 315-75 N86796Perkins Brad · Thomas, OKBuilt 1974 · S/N 659-74 N867AAWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264498 N867CTTessos Air Service Inc · Wilmington, DEBuilt 1976 · S/N 28-7790079 N86806Officer Jarod P · Petaluma, CABuilt 1946 · S/N 1167 N86807Wells Jeffrey V · Mackay, IDS/N 22-74 N8681DWayward Willow LLC · Wasilla, AKBuilt 1958 · S/N 18-6286 N86822Hofer Gary D · Huron, SDBuilt 1974 · S/N 672-74 N8682DCasabonne Family Ltd Partnership · Hope, NMBuilt 1958 · S/N 18-6287 N86838White Sean Patrick · Fairbanks, AKS/N 688-74 N86846Woolard Farms Leasing Inc · Corning, ARBuilt 1974 · S/N 669-74 N8684DScott Lonnie L · Nikiski, AKBuilt 1958 · S/N 18-6289 N86854Moore Planting Co Inc · Cary, MSBuilt 1974 · S/N 6-74 N86863Pruitt Leland L · Jones, LABuilt 1974 · S/N 36-74 N86879Knik Flying Club LLC · Anchorage, AKBuilt 1975 · S/N 856-75 N86883High Exposure Inc · Wilmington, DEBuilt 1974 · S/N 680-74 N86885Mason Peter Trustee · Santa Paula, CABuilt 1974 · S/N 37-74 N8688DHarmon Mike D · Mansfield, SDS/N 18-6295 N86892Goodman Jack · Memphis, TNBuilt 1974 · S/N 296-74

Back to AD 79-10-03 R2