Registered aircraft · 56,580

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-14-R1') 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-14-R1') 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-14-R1')
    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-14-R1')
  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-14-R1')
  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-14-R1')
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.

N3175BSmith Robert J · Easton, PABuilt 1952 · S/N 25417 N3175CClay Jason I · Imperial Beach, CABuilt 1954 · S/N 30974 N3175FEstes Bernard R · Bumpass, VABuilt 1966 · S/N 18257275 N3175JJohnson David J Jr · Yucaipa, CABuilt 1966 · S/N 15065875 N3175UKeller Richard J · Martinsburg, WVBuilt 1963 · S/N 18254575 N3175VDunaire LLC · Mechanicsburg, PABuilt 1974 · S/N 15076408 N3175YPittman Joel C · Apple Valley, CABuilt 1962 · S/N 18254175 N3176AHalbeisen Robert C · Fairbanks, AKBuilt 1953 · S/N 25820 N3176CYoung Thomas O · Battle Ground, WABuilt 1954 · S/N 30975 N3176JAquaero LLC · San Antonio, TXBuilt 1966 · S/N 15065876 N3176XHarless Phillip M · Mcdonough, GAFirst renewal noticeBuilt 1966 · S/N 15064576 N3176YThomas Steven Dale · Monticello, ILS/N 18254176 N3177Duvall John M III · Cincinnati, OHBuilt 1967 · S/N 17700660 N3177JDouble Rr Holdings LLC · Dallas, TXS/N 15065877 N3177SFreeman William R · Lenexa, KSBuilt 1964 · S/N 18255677 N3177TCain James W · Big Rapids, MIBuilt 1967 · S/N 17700477 N3177VSmith Daniel P · St George, UTBuilt 1974 · S/N 15076409 N3177XBandy Suzanne M · Newport, ORBuilt 1966 · S/N 15064577 N3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeBuilt 1962 · S/N 18254177 N3178DSager Kenneth A · Hummelstown, PABuilt 1955 · S/N 31976 N3178JBirmingham Pilot Academy LLC · Birmingham, ALS/N 15065878 N3178TAdvantage Aviation Services LLC · South Saint Paul, MNS/N 17700478 N3178YNiles Air LLC · Concord, NCBuilt 1962 · S/N 18254178 N3179BLevin Lawrence E · North Pole, AKBuilt 1952 · S/N 25421 N3179CWoods Kevin M · Spokane, WABuilt 1954 · S/N 30978 N3179DPreiss James M Trustee · Poplar Grove, ILBuilt 1955 · S/N 31977 N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279 N3179JTri-County Flyers LLC · Morgantown, PABuilt 1966 · S/N 15065879 N3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179 N317ACChickenhawk Inc · Wilmington, MABuilt 1975 · S/N 17265537 N317BLCowboy Aviation LLC · Edmond, OKFirst renewal noticeBuilt 2020 · S/N 172S12466 N317BTAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9828 N317CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12515 N317GTKatz Gary G · Louisville, KYBuilt 1962 · S/N 17249734 N317HDHardrock Drilling LLC · Francesville, INBuilt 2026 · S/N 18283339 N317KAWycka Michelle Sarah · Stayton, ORS/N 18254317 N317KGGouvin Gregory A · West Suffield, CTS/N 25282 N318Liberty University School Of Aeronautics · Lynchburg, VAFirst renewal noticeBuilt 1966 · S/N R172-0006 N31803Mekker Mark S · Getzville, NYS/N 18052420 N3180ARoss Ranch & Livestock Co · Jordan, MTBuilt 1953 · S/N 25824 N3180DKleimer Steve · Bozeman, MTBuilt 1955 · S/N 31978 N3180QA & L Aircraft Holding LLC · Miami Springs, FLBuilt 1967 · S/N 18258180 N3180RThomas Lance E Trustee · Mesa, AZBuilt 1967 · S/N 18258580 N3180UBasan Oasis LLC · Santa Teresa, NMBuilt 1963 · S/N 18254580 N3180YWalker Jim · Lovell, WYBuilt 1962 · S/N 18254180 N3181CFour Boys Aviation LLC · Madison, MSFirst renewal noticeBuilt 1954 · S/N 30980 N3181SWood David M · Purcellville, VABuilt 1964 · S/N 18255681 N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481 N3181XHart George · Roseville, CABuilt 1966 · S/N 15064581 N3182DHanft Thomas A · Oakhurst, CABuilt 1955 · S/N 31980

Back to AD 79-10-14 R1