Registered aircraft · 40,404

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.

N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1390RYancy Timothy J · Chino Hills, CABuilt 1975 · S/N AA5-0790 N13910Coryell James M · Valdez, AKBuilt 1974 · S/N 18-7409055 N13911Northern Aeroworks LLC · Eagle River, AKBuilt 1971 · S/N 18-8972 N1391RMccarthy Daniel J · San Diego, CAS/N AA5-0791 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N13925Lindsay John S · Freeport, PABuilt 1971 · S/N 18-8973 N13927Zerck Joseph W · Anchorage, AKBuilt 1972 · S/N 18-8977 N1392WSale Reported · Lakeland, FLSale reportedBuilt 1964 · S/N 2670 N13931Mahoney Edmund Mont · Anchorage, AKBuilt 1972 · S/N 18-8978 N13937Rafter J Aviation LLC · Moab, UTS/N 18-8979 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N13939Diessner Daniel J · New Smyrna Beach, FLBuilt 1976 · S/N 17702477 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393PSeymour Lori L · Woodstock, GAS/N 23-445 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394WLuniewicz Morgan · Walnutport, PAFirst renewal noticeS/N 2672 N13951Black Timber Aviation LLC · Rifle, COBuilt 1972 · S/N 18-8981 N1395FMoquin Christopher · Chicago, ILS/N 578 38 8392 N1395RKing Rodney R · Lucedale, MSBuilt 1975 · S/N AA5-0795 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066 N1395WRienstra Andrew P · South Lyon, MIBuilt 1964 · S/N 2673 N13960John Mark Air Repair LLC · Chugiak, AKBuilt 1972 · S/N 18-8984 N1396RHodges John J · Cleburne, TXBuilt 1975 · S/N AA5-0796 N1396WD & J Solutions Inc · Nokesville, VABuilt 1964 · S/N 2674 N13973Rs Specialties LLC · Anchorage, AKBuilt 1972 · S/N 18-8985 N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068 N1397WMorris Michael E · Las Vegas, NVBuilt 1964 · S/N 2675 N1398CBennett Eric · Warsaw, INBuilt 1977 · S/N 17702720 N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985 N1398HMiller Debra L · Anchorage, AKS/N 15AC-449 N1398PWolbert Valerie M · Canton, GABuilt 1956 · S/N 23-449 N1398RHopland Steven R · Johnson City, TNBuilt 1975 · S/N AA5-0798 N139AAMeloan Andrew Newton · St Helena Is, SCBuilt 2000 · S/N 04980085 N139BSDonato James J · Hawthorne, FLBuilt 2000 · S/N 11152 N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532 N139FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290174 N139GMclearran Jr William C · Oro Valley, AZBuilt 1979 · S/N 375 N139PCSavage David Edward · American Falls, IDBuilt 2002 · S/N 1339-2002 N139SNMccullough Jacob D · Lockhart, TXBuilt 1965 · S/N 28-2184 N13AHCasady Joseph P · Buckley, WABuilt 1995 · S/N 1334 N13BSSteele Roger H · Cedar City, UTS/N 1259 N13BVGarrett Steven R · Pittsburg, TXBuilt 2003 · S/N 10013

Back to AD 79-10-03 R2