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.

N63275Qualitair LLC Trustee · MichelstadtS/N 18282131N63279P & H Air Inc · Overland Park, KSBuilt 1981 · S/N 17275412N6327ASmith Mathias N · Weiser, IDBuilt 1956 · S/N 33127N6327BNilsen Kim W · Hailey, IDS/N 34227N6327ESpiro Brian F · Wonder Lake, ILBuilt 1959 · S/N 46427N6327SHayton James B · Sedro Woolley, WABuilt 1967 · S/N 15067127N63283Johnston Daniel · Virginia Beach, VABuilt 1975 · S/N 15077227N63285Honan John A · Lincroft, NJBuilt 1975 · S/N 15077228N63287Waters Brandon J · Bushnell, ILBuilt 1975 · S/N 15077230N6328AHsd&R Enterprises Inc · Abilene, TXBuilt 1956 · S/N 33128N6328CArnold Aviation & Thunder Mountain Express Inc · Cascade, IDBuilt 1980 · S/N 21063865N6328EFlies & Floats LLC · Baton Rouge, LABuilt 1980 · S/N 18504025N6328GGoodger Jerome H · Milton, WIBuilt 1970 · S/N 15071828N6328YKoehn Lacey · Van Horn, TXBuilt 1981 · S/N 21064338N63290N63290 LLC · Boulder City, NVBuilt 1975 · S/N 15077232N63293Roesner Alvin R · Indianapolis, INBuilt 1975 · S/N 15077233N6329AAlpine Medical Services Inc · Hayden, IDBuilt 1956 · S/N 33129N6329BN6329b Flyingclub LLC · Farmington, MNBuilt 1957 · S/N 34229N6329CUnited Indian Mission DBA · Tucson, AZBuilt 1977 · S/N U20603844N6329EFeigl Frederick D · Dallas, TXBuilt 1959 · S/N 46429N6329GRegistration Pending · Brodheadsville, PARegistration pendingS/N 15071829N6329YDiablo Aviation LLC · Pleasanton, CABuilt 1981 · S/N 21064339N632AAAerospring Leasing LLC · Wasilla, AKBuilt 2025 · S/N 172S13374N632AHWrasse Mark R · Rosholt, WIBuilt 1957 · S/N 34248N632CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281521N632CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11458N632EHHuddleston Edward L · Oaktown, INBuilt 1973 · S/N A1500467N632ESArvidson Randall C · Brighton, MIBuilt 2004 · S/N 18281384N632LAJoy Air LLC · Scottsdale, AZBuilt 2023 · S/N 172S13109N632LLLinthicum Lane H · Bakersfield, CABuilt 1997 · S/N 18280026N632MRNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282186N632SPWestosha Flying Club Inc · Kenosha, WIBuilt 2000 · S/N 172S8627N632TKKentucky State Police · Frankfort, KYBuilt 2009 · S/N 18282188N6330BGroup Therapy Enterprises Inc · Claremore, OKBuilt 1957 · S/N 34230N6330CLos Angeles County Sheriffs Department · Long Beach, CABuilt 1980 · S/N 21063866N6330DReliant Technologies Incorp · Port Allen, LABuilt 2008 · S/N 18282110N6330ECollins Anthony W · Bowdoinham, MEBuilt 1959 · S/N 46430N6330FHansen Jodi L E · Farmington, MNBuilt 1975 · S/N 18264162N6330SErnst Albert S III · Buda, TXBuilt 1967 · S/N 15067130N6330VLegacy Lsa LLC · Lubbock, TXS/N 172RG0628N63312Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17275419N6331GSound Flight LLC · Auburn, WAS/N 15071831N6332ASkydive Awesome! LLC · Bend, ORBuilt 1956 · S/N 33132N6332DBlue River Aviation LLC · Wasilla, AKBuilt 1979 · S/N 17272720N6332ERampani Joe J · Sullivan, MOBuilt 1959 · S/N 46432N6332GJr Imaging Logistics Inc · Pasco, WABuilt 1970 · S/N 15071832N63332Andavia LLC · Fort Worth, TXBuilt 1975 · S/N 15077241N63336Murry John · Anchorage, AKBuilt 1977 · S/N 18052841N63338Scarbrough Mark B · San Miguel, CAS/N 15077247N6333AHeller Peter C · Denver, COBuilt 1956 · S/N 33133
Back to AD 79-10-14 R1