Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N9650JPalmer Eric · Bowling Green, OHBuilt 1967 · S/N 28-3815 N9650QVon Graff Kurt · Pennington, NJBuilt 1975 · S/N 17265734 N9650VPittman Michael Sr · Chandler, AZBuilt 1974 · S/N 17264430 N9651DKadera David E · Dorchester, IABuilt 1959 · S/N 22-6565 N9651PLedda Robert L · Soldotna, AKBuilt 1974 · S/N 18-7409142 N9651RSchwartz Alan · Hurleyville, NYBuilt 1960 · S/N TD-348 N9651VHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17264431 N9652DWilliams Michael P · Shelburne Falls, MAS/N 22-6566 N9652UFry Anthony J · Rocky River, OHBuilt 1975 · S/N AA5A-0018 N9652VBrown Keno · Athens, TXBuilt 1974 · S/N 17264432 N9652WRegistered aircraftS/N 28-23112 N9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CABuilt 1981 · S/N 172RG0946 N9653DHurt Thomas J · Kerrville, TXBuilt 1959 · S/N 22-6569 N9653JClear Sky LLC · La Grange Park, ILBuilt 1966 · S/N 28-3818 N9653PUhls Keith T · Austin, TXBuilt 1974 · S/N 18-7409144 N9653QMikeska Rudy L · Taylor, TXBuilt 1975 · S/N 17265737 N9653RColorado Northwestern Community College · Rangely, COBuilt 1960 · S/N TD-343 N9653USteffen Todd M · Wind Lake, WIBuilt 1975 · S/N AA5A-0019 N9653WWohl Scott D · Clarkston, WABuilt 1967 · S/N 28-23114 N9654BDonohue Andrew · Tulsa, OKBuilt 1981 · S/N 172RG0947 N9654JMouton Charles J Jr · Gladewater, TXBuilt 1966 · S/N 28-3820 N9654QFly Pioneer Valley LLC · Gill, MABuilt 1975 · S/N 17265738 N9654URealty Investment Co Ltd · Hilo, HIBuilt 1975 · S/N AA5A-0020 N9654VN9654v LLC · Lakeland, FLS/N 17264434 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

Back to AD 80-04-03 R2