Registered aircraft · 40,473

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.

N7192SUniversal Technical Institute Inc · Phoenix, AZBuilt 2000 · S/N 3058 N7192WPope Larry · Lake View, NYBuilt 1963 · S/N 28-1004 N7193DKeech Paul A · Fairbanks, AKBuilt 1957 · S/N 18-5661 N7193LLevison Louis · Klamath Falls, ORBuilt 1974 · S/N AA5-0693 N7194Ajayi Samuel O · Fredericksburg, VAS/N 15063922 N7194BBooker Louis E Jr · Pinetop, AZBuilt 1956 · S/N 22-4390 N7194DBeacon West LLC · Billings, MTBuilt 1957 · S/N 18-5662 N7194GAvco Patrol LLC · Lyndon, KSBuilt 1969 · S/N 17258894 N7194QOzarks Auto Show Inc · Hollister, MOBuilt 1973 · S/N 17260494 N7194RAltair Associates · Middletown, DEBuilt 1966 · S/N 28-21908 N7194WWagner Jeffrey P · Bridport, VTBuilt 1963 · S/N 28-1006 N7195GBurnside George C II · Hattiesburg, MSBuilt 1969 · S/N 17258895 N7195QPuget Sound Flyers · Everett, WABuilt 1972 · S/N 17260495 N7195VScherer Eric · Mooresville, NCBuilt 1975 · S/N 20-1147 N7195WMueller Reinhard B · Sparta, WIBuilt 1963 · S/N 28-993 N7195ZDenis Ranch · Vancourt, TXBuilt 2001 · S/N 3246 N7196LDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N AA5-0496 N7196QBurdis W J · Beaver Falls, PABuilt 1972 · S/N 17260496 N7196RCrisler Capital LLC · Sunnyvale, TXS/N 28-21910 N7196WJets To Helis LLC DBA · Chandler, AZBuilt 2000 · S/N 3140 N7197GFly Wissota LLC · Chippewa Falls, WIBuilt 1969 · S/N 17258897 N7197LMorris Gary M · Lucedale, MSBuilt 1974 · S/N AA5-0697 N7197RTaylor Timothy T · Quitman, ARS/N 28-21911 N7197ZAero Tech Academy Inc · Redlands, CANon-citizen corporation, flight hours not reportedBuilt 2001 · S/N 3249 N7198AFlying J Services LLC · Jourdanton, TXBuilt 2001 · S/N 3216 N7198GJones Lawrence A · St Simons Island, GABuilt 1969 · S/N 17258898 N7198JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 3232 N7198MMcelhannon Fayette M Jr · Athens, GABuilt 1990 · S/N 541R N7198NAero Leasing Inc · Medford, ORBuilt 2001 · S/N 3168 N7198QBay Lux Ventures LLC · Tampa, FLBuilt 1972 · S/N 17260498 N7198RWest Michigan Flying Club Inc · Norton Shores, MIBuilt 1966 · S/N 28-21912 N7199Big Sky Flyers LLC · Billings, MTBuilt 1971 · S/N 419F N7199RBrendemuhl Nathan C · Everett, WAS/N 28-21914 N7199WBobkat Aviation LLC · Louisville, KYS/N 281074 N719ACZing Aviation And Marine LLC · Edgewater, FLBuilt 2001 · S/N 1314-2001 N719AHBanz Charles M · Stuart, FLBuilt 2004 · S/N 70499 N719DDCottrell Mark C · Leitchfield, KYS/N 206 N719GWWayne Alan A · Flowery Branch, GABuilt 1989 · S/N 1809034 N719MDRegistered aircraftBuilt 1997 · S/N 5051 N719MRJts Aircraft LLC · Rock Hill, SCBuilt 1966 · S/N 28-3412 N719RCrowder Gary D · Belt, MTBuilt 2003 · S/N 90263 N71AKWhittlesy Harold A · Anchorage, AKS/N 28-4386 N71CGGraf Mark A · Arvada, COBuilt 1995 · S/N 20982 N71CRSoto Arturo J · Laredo, TXBuilt 1963 · S/N 2411 N71DBBlanton Robert D · Wichita, KSBuilt 1971 · S/N 1 N71FHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1724M N71FPArndt James R Jr · Round Rock, TXBuilt 1978 · S/N AA5A0643 N71GARosso Corsa Motors Inc · Colorado Springs, COBuilt 2004 · S/N 3727 N71HHEastern Slope Aviation Academy · North Conway, NHBuilt 1971 · S/N 17260295 N71JAIcenogle Roger A · Inver Grove, MNBuilt 2004 · S/N 2284

Back to AD 80-04-03 R2