AD 79-10-14 R1

Registered aircraft · 56,582

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

N4696FTorres Roberto · Bavamon, PRBuilt 1979 · S/N 17273073N4696K96 Kilo LLC · Modesto, CABuilt 1975 · S/N 18263697N4696LKoontz Marina M · Seattle, WABuilt 1966 · S/N 17254691N4696XAval Aviation LLC · Las Vegas, NVBuilt 1966 · S/N 15064746N4697GVeety Roy D · Dalton, PAS/N 17273323N4697KMorgan James D · Denali Park, AKBuilt 1975 · S/N 18263698N4697LTverberg Justin T · Omak, WABuilt 1966 · S/N 17254692N4697NWang Kun · Whitestone, NYS/N 18267291N4698C98 Charlie LLC · Anchorage, AKBuilt 1974 · S/N 18502598N4698DDrm Aviation LLC · Glencoe, ALBuilt 1979 · S/N 17272333N4698KRegistered aircraftBuilt 1975 · S/N 18263699N4699AReed Aviation LLC · Pearl, MSBuilt 1956 · S/N 32296N4699FStinson Ryan · Eagle, IDBuilt 1966 · S/N P206-0299N4699UValdez David M · Shady Shores, TXBuilt 1964 · S/N 18051399N4699WN4699w LLC · Rutherford, CABuilt 1981 · S/N 18268131N469DCLaw David L · Derby, KSBuilt 1979 · S/N 18266646N469DTBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 18280773N469ERMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8940N469FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10884N469MBFloriflt LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9944N469MHWhat Could Go Wrong LLC · Murfreesboro, TNBuilt 2025 · S/N 18283324N469NETauber Samara R · La Jolla, CAFirst renewal noticeBuilt 1983 · S/N 17275952N469TCEast Pole Aviation LLC · E Setauket, NYBuilt 2001 · S/N 18280989N46AMDuffy Kevin · Manchester Center, VTBuilt 1959 · S/N 52130N46BCHfc Inc · Halma, MNBuilt 1967 · S/N U206-0826N46CAEnglehart James C · Marietta, GABuilt 1969 · S/N 15070135N46EFPringle Dan · Charlestown, INS/N 18280992N46FFFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12874N46GMDeffner Gerhard Paul Heinrich · Mckinney, TXS/N 17235N46JFTisdell Michael S · Olivia, MNBuilt 1986 · S/N 18268563N46JWWerner John D · Pownal, VTBuilt 1969 · S/N 17257942N46MPAnderson Howard E · Luray, VABuilt 1983 · S/N 172RG1144N46MRDavin Matthew · Ridgecrest, CABuilt 1975 · S/N 21060778N46PCMace Robert C Jr · Gold Canyon, AZS/N 21060105N46PGRegistered aircraftBuilt 1972 · S/N 18261414N46PKTensas Taildraggers LLC · Saint Joseph, LABuilt 1978 · S/N U20604437N4700FAssociated Equip Representatives Inc · Yakima, WABuilt 1966 · S/N P206-0300N4700XCerasia Steven S · Amsterdam, NYBuilt 1966 · S/N 15064750N4701DMiller Larry L · Dade City, FLBuilt 1957 · S/N 34801N4701QWindsor Greg A · Anchorage, AKBuilt 1966 · S/N 185-1155N4701URegistered aircraftBuilt 1964 · S/N 18051401N4702FSouthern Aces LLC · Geneva, FLBuilt 1979 · S/N 17273074N4702KUniversity Auto Sales Inc · Pell City, ALBuilt 1975 · S/N 18263701N4702QDriggs Daniel H · Anchorage, AKBuilt 1966 · S/N 185-1156N4702WFour Flying Fools LLC · Geneva, FLS/N 57532N4703KSkeffington Robert C · Topsfield, MABuilt 1975 · S/N 18263702N4704ABrown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 18502426N4704CWright Brian A · Nampa, IDBuilt 1956 · S/N 33738N4704GRegistration Pending · Spencerville, OHRegistration pendingS/N 17273326N4704NScott Lester N · Pleasanton, CAFirst renewal noticeBuilt 1979 · S/N 18267294
Back to AD 79-10-14 R1