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.

N571SPChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8496N571TCPardue Troy W · Downsville, LABuilt 2006 · S/N 20608271N571VHVan Hoy Jeffrey D · Knightstown, INBuilt 1965 · S/N 15062392N5720CRegistration Pending · Bellevue, NERegistration pendingS/N 19826N5720EInstall Pro Construction LLC · Henderson, NVBuilt 1978 · S/N 17271926N5720TFrost Nathan L · Olympia, WABuilt 1964 · S/N 17251620N5721TSeattle Seaplanes LLC · Seattle, WABuilt 1964 · S/N 17251621N5722BVelasquez Benjamin · Anchorage, AKS/N 33722N5722CNeumann John F · Walden, NYBuilt 1950 · S/N 19676N5722EWinfrey Walter A Trustee · Auburn, CABuilt 1959 · S/N 17222N5722GSchmitt Rudy · Bulverde, TXBuilt 1969 · S/N 15071222N5722RCalhoun Barry R · Richardson, TXBuilt 1965 · S/N 17253387N5723AAdamson Steven C · Jonesboro, GAS/N 28323N5723CMid Pacific Aero Services LLC · Wahiawa, HIBuilt 1951 · S/N 19677N5723JMcdonald Larry H · Little River, SCBuilt 1974 · S/N 18263498N5723RCoffey Bryan K · Anchorage, AKBuilt 1965 · S/N 17253389N5723TColeman David R · Limerick, MEBuilt 1964 · S/N 17251623N5724CRegistered aircraftS/N 19827N5724EGroup 59 LLC · Oro Valley, AZBuilt 1959 · S/N 17224N5724GCrnic John F · Kirksville, MOBuilt 1969 · S/N 15071224N5724JPurdue Aviation LLC · West Lafayette, INBuilt 1980 · S/N 17273827N5724RMartindale Bryan T · Springfield, ILBuilt 1965 · S/N 17253393N5726BBend Aircraft Rentals LLC · Bend, ORBuilt 1956 · S/N 33726N5726CPurcell Kim L · Placerville, CABuilt 1950 · S/N 19680N5726THall Edward M · Brainerd, MNBuilt 1964 · S/N 17251626N5727EZeitvogel Jeanine · Gulf Shores, ALBuilt 1978 · S/N 17271928N5727NQualitair LLC · MicheistadtBuilt 1977 · S/N 18503320N5727RBiederman Scott · Pompano Beach, FLS/N 17253396N5728AMcgiffen Christine L · Vincennes, INBuilt 1956 · S/N 28328N5728BHawkins Charles A Sr · Chillicothe, OHBuilt 1956 · S/N 33728N5728EThibodeau Thomas J · Honea Path, SCBuilt 1959 · S/N 17228N5729AThomas Scott S · Wytheville, VABuilt 1956 · S/N 28329N5729ERhoades James W · Little Falls, MNBuilt 1959 · S/N 17229N5729RMarreno Eddie J · Green Cove Springs, FLS/N 17253398N5729TConservair Inc · Montgomery, TXBuilt 1964 · S/N 17251629N572BWBridgewater State University · Bridgewater, MABuilt 2003 · S/N 172S9426N572DHSportsmans Recon LLC · Hartwell, GABuilt 1974 · S/N 18263024N572EEcho Air LLC · Anchorage, AKBuilt 1972 · S/N 18502089N572GSickles James D · Caledonia, NYBuilt 1969 · S/N 18259932N572JAJ.A. Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10553N572NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10940N572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1973 · S/N 17261600N572SPOld Friend Air LLC · Junction City, ORBuilt 2000 · S/N 172S8498N5730AMunson Steven L · Martinsburg, WVBuilt 1956 · S/N 28330N5730JLindley Field Flying School LLC · Greensboro, NCBuilt 1980 · S/N 17273828N5731CSmith Michael E · Willits, CABuilt 1951 · S/N 19685N5731JPaulick Adam J · Deerfield, WIBuilt 1969 · S/N P20600631N5731RGoward Steven Lee · Oakley, MIBuilt 1965 · S/N 17253400N5731TUhen Instruments Inc · Burlington, WIS/N 17251631N5732CHoulton Timbre R · Fairbanks, AKBuilt 1950 · S/N 19686
Back to AD 79-10-14 R1