OpenAirDocs.org
AD 79-10-03 R2

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
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.

N5638ULig Tyl LLC · Akron, NYBuilt 1969 · S/N 28-26435N56396Sky North Aviation & Flight Training LLC · Arbuckle, CABuilt 1973 · S/N 287325623N5639FTaffet Jay · New Orleans, LABuilt 1976 · S/N 28-7790132N5639PMarchetti Nancy K · Port Charlotte, FLS/N 24-709N5639UMcconnell Charles L · Phoenix, AZBuilt 1969 · S/N 28-26434N563DRural Air Medical LLC · Farmington, UTBuilt 2001 · S/N 2172N563FLParkerson James R · Greenville, MSS/N 28-7125405N563GLBole David M · Auburn, WABuilt 1988 · S/N 7226-E-563N563PUAri Ben Aviator Inc · Fort Pierce, FLBuilt 2000 · S/N 2842105N56404Mark Lindstrom · Fort Worth, TXBuilt 1973 · S/N 287305586N56406Blankenship Tyler D · Salisbury, NCBuilt 1980 · S/N 8013CN5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909N5640NK Top J Cattle Co LLC · Eldorado, TXBuilt 1980 · S/N 8010CN5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436N5641VFlight Leasing Corp · Wilmington, DES/N 28-7716188N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789N56424Saunders Equipment Inc · Cold Spring, NYBuilt 1981 · S/N 8017CN56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628N5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049CN56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591N5643QGray Eric W · Erie, COBuilt 1965 · S/N 3020N5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439N5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019CN5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595N5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596N5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003N5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N5649PTalarek Kai C · Far Hills, NJBuilt 1959 · S/N 24-720N5649QTaylor Clayton T · Stockton, KSBuilt 1965 · S/N 3023N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808N564DFPreiss Michael C · Southaven, MSS/N 269N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406N564PUPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 2842169N5651BRoland David K · Lockhart, TXBuilt 1981 · S/N 8018CN5651QKingdom Air LLC · Diamondhead, MSBuilt 1965 · S/N 3024N5652Leary Brian J · Fredricksburg, PABuilt 1972 · S/N 595N56521Hawkes Tyler · Rexburg, IDBuilt 1973 · S/N 28-73-25647N56524Registration Pending · West Palm Beach, FLRegistration pendingS/N 28-73-25650N56525Sadi Susan Salimi · Arlington, TXS/N 28-7325651N5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912
Back to AD 79-10-03 R2