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.

N9655JDunn James Blair Jr · Bumpass, VABuilt 1966 · S/N 28-3822 N9655MJarco Group LLC · Lititz, PABuilt 1967 · S/N 670111 N96567Gmt Aviation LLC · Newtown, CTBuilt 1984 · S/N 17276086 N9656DSpearman Clint · Scottsbluff, NEBuilt 1959 · S/N 22-6572 N9656JVolpe Robert · Holiday, FLBuilt 1966 · S/N 28-3823 N9656MWashington Aviation Inc · Seattle, WABuilt 1967 · S/N 670112 N9656PLee Gerald R · Glennallen, AKBuilt 1974 · S/N 18-7409149 N9656QMccort Daniel R · Pensacola, FLBuilt 1975 · S/N 17265740 N9656RGlenn Jeff P · Billings, MTBuilt 1960 · S/N TD-331 N9656ULanglois Zachary J · Deerfield, NHBuilt 1975 · S/N AA5A-0022 N96573Condor Aero Club Inc · Zelienople, PABuilt 1984 · S/N 17276088 N96575Biryukov Ruslan B · Encino, CABuilt 1984 · S/N 17276089 N96576Baxter David C · Saint Helens, ORBuilt 1989 · S/N 1332 N96579Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276090 N9657PJacobsen Nathaniel · Juneau, AKBuilt 1974 · S/N 18-7409150 N9657SWhite Wayne A · Scenic, SDBuilt 1966 · S/N 26 N9657VChorman Spraying LLC · Milton, DEBuilt 1974 · S/N 17264437 N9657WNorth Stephen P · Rochester, NYBuilt 1967 · S/N 28-23119 N9658DSwann Sherrie Kim Trustee · Toledo, OHBuilt 1959 · S/N 22-6574 N9658KFlying Particles Inc · Livermore, CABuilt 1976 · S/N 28-7690271 N9658URegistration Pending · Spencer, NERegistration pendingBuilt 1975 · S/N AA5A-0024 N9658WGraham Joel A · Marietta, GABuilt 1967 · S/N 28-23120 N9659HJd Griffin LLC · Wilmington, DEBuilt 1975 · S/N 17266296 N9659LMoffatt Thomas · Dallas, GABuilt 1974 · S/N AA5-0659 N9659QMacrafic Bruce A · Garden City, MNBuilt 1975 · S/N 17265743 N9659SRandall Timothy J · Skidmore, MOBuilt 1966 · S/N 69 N9659WMitchell Matthew · Ypsilanti, MIBuilt 1967 · S/N 28-23121 N965ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841134 N965JDCircling Sky Aviation LLC · Canton, MSBuilt 2002 · S/N 5115 N965MMBastian Devan · Vernal, UTS/N 15060836 N965MSMt San Antonio College · Walnut, CABuilt 1973 · S/N 17261395 N9660BHenry Lawrence D · Lohman, MOBuilt 1981 · S/N 172RG0952 N9660HCdb Group Holdings LLC · Sheridan, WYBuilt 1975 · S/N 17266297 N9660PCook Timothy L · Eagle River, AKBuilt 1975 · S/N 18-7509004 N9660WAlaimo Thomas J · Napa, CABuilt 1967 · S/N 28-23122 N96616Air Transport Inc DBA · Las Vegas, NVS/N 17276094 N9661JGrant Michael T · Eugene, ORBuilt 1966 · S/N 28-3829 N96621D Gordon Aviation Inc · La Jolla, CABuilt 1984 · S/N 17276096 N96626Wingsleasing LLC · Wichita, KSBuilt 1984 · S/N 17276097 N96628Bobby Nelson Aviation LLC · Kettering, OHBuilt 1984 · S/N 17276098 N9662QHomiller Robert S · Bear, DEBuilt 1975 · S/N 17265746 N9662UT & J Services Inc · Wilmington, DEBuilt 1975 · S/N AA5A-0028 N9662VLevel X Aviation LLC · Royal Palm Beach, FLBuilt 1974 · S/N 17264442 N9663DRamsey Bobby W · Harrogate, TNBuilt 1959 · S/N 22-6579 N9663JN9663j LLC · Dallas, TXBuilt 1967 · S/N 28-3877 N9663PDilse Brian R · Grand Forks, NDS/N 18-7509008 N9663UMaxfield Ronald · Mechanicsville, VABuilt 1975 · S/N AA5A-0029 N9664PYundt Joshua J · Wasilla, AKBuilt 1975 · S/N 18-7509001 N9664UBoan Timothy C · Berryville, VABuilt 1975 · S/N AA5A-0030 N9665HDouble Bridges Aviation LLC · Enterprise, ALBuilt 1975 · S/N 17266300

Back to AD 79-10-03 R2