AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-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:2007-04-19-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.

N5206RNewlon Rudolf W · Encinitas, CAFirst renewal noticeS/N 17263423N5206UMudminers LLC · Wasilla, AKBuilt 1964 · S/N 206-0206N5206YHart Lewis W DBA · Rexburg, IDBuilt 1962 · S/N 27-2254N52070Cendejas Agustin · Chino, CABuilt 2002 · S/N 172S9077N52072Wicked Wings Aviation LLC · Dover, DEBuilt 2002 · S/N 18281137N5207GBeck Gary F · Lake Havasu City, AZS/N 21645N5207KJennings Stephen P · Greenwood, MSBuilt 1950 · S/N NAV-4-2107N5207LDon'T Panic! LLC · Vancouver, WABuilt 1967 · S/N 28-4498N5207PRisi John D · Erie, COS/N 24-231N5207QDairy Air Inc · Wyoming, PABuilt 1973 · S/N 17261771N52082Birdsall Mark A · Berthold, NDBuilt 1980 · S/N 17274408N52083Gorn Anthony S · Nome, AKBuilt 1974 · S/N 18052488N52084Lutz Adam R · Kodiak, AKBuilt 1974 · S/N 18052489N5208ASturges George S · Willis, TXBuilt 1956 · S/N 35408N5208DVarsity Flight Ops LLC · Las Vegas, NVBuilt 1979 · S/N 17272451N5208EHelmericks Mark H · Anchorage, AKS/N 50508N5208GSnider Gary L · West Des Moines, IABuilt 1951 · S/N 21936N5208JFly Dreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273732N5208NMcmillan Robert M · Yucca Valley, CABuilt 1947 · S/N NAV-4-948N5208PDale Snooks One On One Inc · Mancelona, MIBuilt 1958 · S/N 24-232N5208RL & S Flyer LLC · Old Saybrook, CTBuilt 1979 · S/N 172RG0047N5208TGarrett Jerry M · Shreveport, LAS/N 28-7225353N52090Bradley Flying Assoc · Peoria, ILBuilt 1980 · S/N 17274409N52095Reberry Brian K · Boise, IDBuilt 1974 · S/N 18052496N52096Lake Pre Mix Inc · Sandpoint, IDBuilt 1974 · S/N 18052497N5209COlson Alan G · New London, MNBuilt 1979 · S/N 21063716N5209DBens Travel Gear LLC · Mountain Home, ARBuilt 1957 · S/N 50107N5209GFlax Brian J · Germantown, TNBuilt 1951 · S/N 21811N5209JDallas Aero & Sales LLC · Poplar, MTBuilt 1977 · S/N 310R1000N5209LKing Christian T · Rhinelander, WIBuilt 1967 · S/N 28-4501N5209NRiver City Aero Club Inc · Columbus, GABuilt 1980 · S/N 18267572N5209RGuyer Kasey A · Billings, MTBuilt 1974 · S/N 17263426N5209VHawkbill Aviation LLC · Hudson, NCBuilt 1980 · S/N 172RG0470N5209WBeck Richard C · Wellington, ALBuilt 1961 · S/N 28-245N520AFAmeriflyers Of Texas Inc · Addison, TXBuilt 2021 · S/N 28020049N520AZSaydun LLC · Richardson, TXBuilt 1966 · S/N 27-3424N520BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842257N520BCMitchell Bruce P · Medford, ORBuilt 2004 · S/N 0996N520BSHanshew James M · Phoenix, AZBuilt 2004 · S/N 81255N520BWWheadon William J · Napa, CABuilt 2019 · S/N 2045N520CAGruia Alin · Beaverton, ORBuilt 1977 · S/N 13187N520CDYounger Helen J · Fair Oaks Ranch, TXBuilt 1976 · S/N 18265118N520CWCentral Washington University · Ellensburg, WABuilt 2017 · S/N 2843921N520DGrimes Brian T · Kingman, AZBuilt 2008 · S/N 051SRN520EPMiles In The Sky LLC · Springfield, MOBuilt 2010 · S/N 18282274N520FLSiry Kristina · Mertztown, PABuilt 1971 · S/N 28-7125345N520HKirsch Kenneth L · Carneys Point, NJBuilt 1975 · S/N 325N520HTEnzminger Joseph R · Austin, TXBuilt 1956 · S/N CG-150N520KSH2 Link Company · Lewes, DEBuilt 2004 · S/N 172S9734N520KTTroendle Adam J · Dexter, MNBuilt 2026 · S/N 4931
Back to AD 2007-04-19 R1