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.

N6333BEspiricueta William L · Denver, COS/N 34233N6333EProstar Flight Services LLC · Bozeman, MTBuilt 1983 · S/N 18268359N6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273193N6333GEule James M · Eagle River, AKS/N 15071833N6333SVano Andrew · Carlos, MNBuilt 1967 · S/N 15067133N63341Puget Sound Flyers Inc · Everett, WAS/N 15077250N63342Vmax Aviation LLC · Uhrichsville, OHBuilt 1975 · S/N 15077251N63346White Thomas L · Willow Springs, MOBuilt 1975 · S/N 15077253N6334BS&D Spraying Service Inc · Panhandle, TXBuilt 1957 · S/N 34234N6334ESrygley Donald E · Muscle Shoals, ALBuilt 1959 · S/N 46434N6334WColwell Kevin · Middleton, WIBuilt 2008 · S/N 18282108N63352Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275425N63359Flick Adam C · Findlay, OHBuilt 1975 · S/N 15077261N6335ECorro Lee A · Holden, MES/N 46435N6335GHaslam Russell L · Meeker, OKS/N 15071835N6335ZLs Express LLC · Syosset, NYBuilt 2008 · S/N 18282128N63362Bels Holdings LLC · Albert Lea, MNBuilt 1975 · S/N 15077262N63363Shaner John D · Tallahassee, FLBuilt 1975 · S/N 15077263N63366Purdue Aviation LLC · West Lafayette, INBuilt 1981 · S/N 17275426N63368Lorenzen Kraig Elmer · Pagosa Springs, COBuilt 1977 · S/N 18052842N6336BNorris Donald A III · Edmond, OKBuilt 1957 · S/N 34236N6336KFlanders Steve L · Brea, CAS/N 15077650N6336UBravo Whiskey LLC · Missoula, MTBuilt 1985 · S/N 21064937N6336VKman LLC · Kalispell, MTBuilt 1980 · S/N 172RG0632N63371Flight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10813N63375Pocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15077268N63376Devaney Aviation Inc · Palm City, FLBuilt 1975 · S/N 15077269N6337AAilf Marketing LLC · Port Charlotte, FLS/N 33137N6337BMckee Bradley Cole · Taylor, TXBuilt 1957 · S/N 34237N6337DHomerace Inc DBA · Tulsa, OKBuilt 1979 · S/N 17272723N6337KK-Ville Flyers LLC · Newmanstown, PABuilt 2008 · S/N 18282135N6337VFirelight Ventures LLC · Fuquay Varina, NCBuilt 1980 · S/N 172RG0633N6337XUnique Educational Experiences Inc · Long Beach, CABuilt 2008 · S/N 172S10812N63384Sa Kim J · Hayward, CABuilt 1975 · S/N 15077274N6338ALittle Bird Airways LLC · Hamburg, NYBuilt 1956 · S/N 33138N6338BSlad George W · Albuquerque, NMBuilt 1957 · S/N 34238N6338DEdb Air Inc · Wilsonville, ORBuilt 2008 · S/N 172S10814N6338EBarber Theodore C Trustee · Spanish Fork, UTBuilt 1959 · S/N 46438N6338FRaritan Valley Flying School · Princeton, NJBuilt 1979 · S/N 17273195N6338GEron Patrick · Hatley, WIBuilt 1970 · S/N 15071838N6338KBurchinal Sam F · Brookston, TXBuilt 1975 · S/N 15077652N63395Reiman Jeffrey Scott · Chandler, AZBuilt 1975 · S/N 15077282N63399Vogt Gerald J · Erie, PABuilt 1975 · S/N 15077284N6339AHockenberry Tyler F · Royse City, TXBuilt 1956 · S/N 33139N6339CBowles Donald E Jr · Dallas, TXBuilt 1980 · S/N 21063871N6339DContrails II Inc · Kerrville, TXS/N 17272725N6339EJudge Nathan E · Coeur D Alene, IDBuilt 1959 · S/N 46439N6339SDamico Thomas J · West Bend, WIBuilt 1967 · S/N 15067139N633BCOneal Brittany H · Palestine, TXS/N 17274633N633CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281528
Back to AD 79-10-14 R1