Registered aircraft · 40,396

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.

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 N71KTL L C LLC · Rapid City, SDBuilt 1965 · S/N 28-21258 N71LZGriffin Ralph J Jr · Thibodaux, LABuilt 1977 · S/N 28-7816275 N71PKBob Hoover Academy · Salinas, CABuilt 1974 · S/N 17263272

Back to AD 79-10-03 R2