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.

N92788Bas Part Sales LLC · Greeley, COS/N 18260357N92789N5746u LLC · Dover, DES/N 17261619N9278AHanna Mark W II · Pendleton, INBuilt 1950 · S/N 19371N9279XKhoury Alain W · Wills Point, TXBuilt 1961 · S/N 18253679N927AZN927az LLC · Miami, FLBuilt 2002 · S/N 172S9090N927CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8915N927GHB R S Leasing Inc · Wilmington, DEBuilt 2005 · S/N 172S10024N927GPChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12409N927NBlue Sky Business Services Inc · Gardiner, NYBuilt 1970 · S/N 18260320N927TCWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264152N927TSM & G Aircraft Management LLC · Aurora, ORBuilt 2023 · S/N 172S13067N9280BDreessen Steven C · Walkerton, INBuilt 1958 · S/N 55080N9280MRiley Dean A · Friday Harbor, WABuilt 1972 · S/N 17260490N9280TChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12413N92810Dilse Brian R · Grand Forks, NDBuilt 1973 · S/N 17261626N92814Kimbrell Tod L Jr · Itasca, TXBuilt 1970 · S/N 18260371N92815Halver Todd L Trustee · Advance, NCBuilt 1970 · S/N 18260372N92816Van Cleve G Steven · Windermere, FLBuilt 1970 · S/N 18260373N92817Millner James W Sr · Soldotna, AKBuilt 1973 · S/N 17261628N9281ABuiqui Aerospace Corp · Kissimmee, FLBuilt 2022 · S/N 172S12787N9281GRuffner Scott A · Luray, VABuilt 1971 · S/N 18260821N9281UOtters Heinrich · Fredericksburg, TXBuilt 1976 · S/N 15078231N92822Roada Inc · Indio, CABuilt 1970 · S/N 18260378N92824C182 Wv LLC · Charleston, WVBuilt 1970 · S/N 18260380N9282AWest Sheryl M · Champlin, MNBuilt 1949 · S/N 19043N9282TCloud 9 Aviators LLC · Anchorage, AKBuilt 1960 · S/N 50782N9282USchur David · Lavernia, TXBuilt 1976 · S/N 15078232N92836Clark Wyatt · Ione, CABuilt 1970 · S/N 18260382N92837Staszak Sandra · Martinsville, ILBuilt 1973 · S/N 17261631N9283AFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12788N9283CFoerschler Dale · North Aurora, ILBuilt 1980 · S/N 17273783N9283GTexas Forever LLC · Denver, COBuilt 1971 · S/N 18260823N9283RAllied Sprayers Inc · Hawley, TXBuilt 1975 · S/N 18802211N92843Roehl John F Jr · Neapolis, OHBuilt 1970 · S/N 18260389N92844Smooth Sailing Flying Club Inc · Avon, INBuilt 1970 · S/N 18260390N92845Hainet Aero LLC · Wilmington, DEBuilt 1973 · S/N 17261633N92846Evans Millard D · Mobile, ALS/N 18260392N9284BBeckley Larry · Scottsburg, INBuilt 1958 · S/N 55084N92850Nelson Tabor K · Corona, CABuilt 1970 · S/N 18260395N92855Falcon Flying Club · Mesa, AZBuilt 1973 · S/N 17261634N9285HOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1975 · S/N 17266068N9285XBlu Kaya LLC · Austin, TXS/N 18253685N92866Green Edward L · Chico, TXBuilt 1970 · S/N 18260403N9286ASimon Theodore E · Richmond, MIBuilt 1949 · S/N 19048N9286BHall Leslie E · Lubbock, TXS/N 55086N9286CQueen City Flying LLC · Helena, MTBuilt 1955 · S/N 31385N9286RWiebe Aerial Applications LLC · Peabody, KSBuilt 1975 · S/N 18802212N9286XRogne Fred A · Fallon, NVBuilt 1961 · S/N 18253686N92873Sonday Terrance P · Spring, TXBuilt 1973 · S/N 17261636N92878Jackson Richard L · Indianapolis, INBuilt 1973 · S/N 17261638
Back to AD 79-10-14 R1