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.

N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417N4871FFry Robert S Jr · Poplar Grove, ILBuilt 1966 · S/N U206-0571N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381N4872UBushwackers Leasing LLC · Calera, OKBuilt 1964 · S/N 205-0572N4873DRagan Matthew T · Boulder City, NVBuilt 1958 · S/N 34973N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420N4874QSutton Aircraft Salvage LLC · Palmer, AKBuilt 1978 · S/N 18503567N4876DAcute Holdings LLC · Jenks, OKBuilt 1958 · S/N 34976N4876FCosta Air Service LLC · Painted Post, NYBuilt 1979 · S/N 17273094N4876GKing Bryan A · Austin, TXBuilt 1979 · S/N 17273423N4876UCottrell Seth M · Kenai, AKBuilt 1964 · S/N 205-0576N4876YCarson Engineering And Manufacturing Inc · Springdale, ARBuilt 1980 · S/N 21064025N4877DAviator Air Flight School LLC · Grand Prairie, TXBuilt 1979 · S/N 17272383N4877JR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273687N4878DCache La Poudre LLC · Fairfield Bay, ARBuilt 1958 · S/N 34978N4878FNistler Gabriel R · Helena, MTBuilt 1966 · S/N U206-0578N4878QRichter Patrick A · Edna Bay, AKBuilt 1978 · S/N 18503570N4878Y182b LLC · La Plata, NMBuilt 1980 · S/N 21064026N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384N4879FCitizen Air LLC · Port Angeles, WABuilt 1966 · S/N U206-0579N487ERCloudchasers LLC · Colorado Springs, COS/N 172S10547N487MTGilmore Bobby Keith · Swifton, ARBuilt 1958 · S/N 46040N487SPArchimedes Aviation LLC · Livermore, CABuilt 2001 · S/N 172S8765N487XACrafa Steven J · Golden, COBuilt 1973 · S/N 15075242N4880DBernstein Timothy D · Faith, SDBuilt 1958 · S/N 34980N4880FFkm Air Shuttle LLC · Brooklyn, NYBuilt 1979 · S/N 17273095N4880GCifelli George J · Dothan, ALFirst renewal noticeBuilt 1979 · S/N 17273427N4880NFront Porch Air LLC · Dalton, GABuilt 1979 · S/N 18267432N4880UYanikoski Joseph A · Stoughton, MABuilt 1984 · S/N 21064831N4881DBurt Compton Enterprises Inc · Marfa, TXBuilt 1958 · S/N 34981N4881EFulltron Aviation LLC · Springfield, MOBuilt 1978 · S/N 17271672N4881QAir Dakota Flite Inc. · Hettinger, NDBuilt 1976 · S/N 18802617TN4881U270 W Pearl LLC · Jackson, WYS/N U20605139N4882NCreative Strategies Inc · Proctorville, OHBuilt 1979 · S/N 18267434N4883DKingdom Air Corps · Sutton, AKBuilt 1958 · S/N 34983N4883FStillinger David C · Cardiff By The Sea, CABuilt 1966 · S/N U206-0583N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430N4884DGarcia Robert · Arcadia, CABuilt 1958 · S/N 34984N4884NCure Louie M · Granbury, TXBuilt 1979 · S/N 18267436N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432N4885XEggleston Kevin M · Moore, OKS/N 21060885N4886DRegistered aircraftBuilt 1958 · S/N 34986N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433N4886NMartin Barry W Trustee · San Diego, CAS/N 18267438N4886USkycase Leasing LLC · Wasilla, AKBuilt 1979 · S/N U20605144N4887Carroll Daniel G · Magnolia, TXBuilt 1976 · S/N 18052720N4887DShank Lawrence · Pagosa Springs, COBuilt 1958 · S/N 34987N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434
Back to AD 79-10-14 R1