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.

N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512N564MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275714N564PCHargest Custom Cabinetry LLC · Clermont, NJBuilt 1998 · S/N 18280248N564QLSimcic Kathryn C · Grain Valley, MOBuilt 1969 · S/N 15070570N5650BPlane Life LLC · Wilmington, DEBuilt 1956 · S/N 33650N5650CMorris Kenneth E · Poplar Grove, ILBuilt 1950 · S/N 15604N5650TWander Harry J · Nevada City, CABuilt 1964 · S/N 17251550N56511Wired Flight LLC · Kent, WABuilt 1974 · S/N 18502525N5651RChickasha Wings Inc · Chickasha, OKBuilt 1965 · S/N 17253279N5651TRegistered aircraftS/N 17251551N5652APatriot Aviation · Loomis, CABuilt 1956 · S/N 28252N5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912N5653BKey Jon · Seminole, TXFirst renewal noticeBuilt 1956 · S/N 33653N5653GCavanaugh Joseph Rex · Alvin, TXBuilt 1969 · S/N 15071153N5654CGelardo Matthew L · Cardiff By The Sea, CAS/N 15610N5654GNorman Charles E · Zanesville, OHBuilt 1969 · S/N 15071154N5654RSudbrink Charles D · Willet, NYS/N 17253283N5654THayes Travis · Harrisonville, MOS/N 17251554N5655GAnderson Kevin G · Pleasant Hill, CABuilt 1969 · S/N 15071155N5656CScully Michael J · San Carlos, CAS/N 15612N5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913N5656GLet There Be Flight LLC · Portage, MIBuilt 1969 · S/N 15071156N5657ENobis Chase · Lyons, MIBuilt 1959 · S/N 17157N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287N56581United States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502907N5658AEwartsville Flyers LLC · Pullman, WABuilt 1956 · S/N 28258N5658BSheyman Igor · Danville, CAS/N 33658N5658REilers Scott D · Amissville, VABuilt 1965 · S/N 17253289N5659AChaouki Rebecca · La Crosse, WIBuilt 1957 · S/N 28259N5659BAom Aircraft LLC · Wilmington, DEBuilt 1956 · S/N 33659N5659EBrewer Randall K · Bloomington, INBuilt 1958 · S/N 17159N5659GLacy Melodi J · Swanton, VTBuilt 1969 · S/N 15071159N5659JGilbert Duane A · Reno, NVBuilt 1974 · S/N 18263481N5659TMorgan Peter Thomas · Bellingham, WABuilt 1964 · S/N 17251559N565ADPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9991N565CHTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13493N565CMBackcountry Aviation LLC · North Salt Lake, UTBuilt 1968 · S/N U2061044N565EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12877N565KGGilley Jerry · Maryville, TNBuilt 1973 · S/N 18261775N565MCAviator Air Flight School LLC · Grand Prairie, TXBuilt 2000 · S/N 18280782N565NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10797N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347N565SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608188N565SMMuller Scott B · Verbank, NYS/N 18267914N565SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8489N565UEsposito John A · Rye, NHBuilt 1963 · S/N 206-0065N5660BHarlow Brett · Pryor, OKBuilt 1956 · S/N 33660N5660GLawrence Corey R · Bourbon, MOBuilt 1969 · S/N 15071160N5660RSpirit Hills Ranch LLC · Belgrade, MTBuilt 1965 · S/N 17253292N5660TChoose You LLC · Twin Falls, IDS/N 17251560
Back to AD 79-10-14 R1