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.

N288WPPhillips William D · Forsyth, GAFirst renewal noticeBuilt 2011 · S/N 81808N28907Warren Scott D · Lucerne, CABuilt 1979 · S/N 28-7990434N2890FAeolus Aviation LLC · Franklin, TNBuilt 1966 · S/N 18256990N2890QCarrick Christopher A · Castro Valley, CABuilt 1971 · S/N 17259890N2890WAlbatross Aviation LLC · Lakeville, OHBuilt 1973 · S/N D-9510N2890YWomble Warren G · Chapel Hill, NCBuilt 1962 · S/N 18253890N28913Bellas Business LLC · Kalispell, MTBuilt 1973 · S/N 340-0153N28917Turnage Andrew · Houston, TXBuilt 1978 · S/N AA5B0888N2891ARegistered aircraftBuilt 1953 · S/N 30091N2891FBayshore Properties LLC · Hagerstown, MDBuilt 1966 · S/N 18256991N2891PHula Jesse M · Anchorage, AKBuilt 1956 · S/N 18-4489N2891TVagias Janet Rose · Niceville, FLBuilt 1972 · S/N 28-7225270N2891ZSale Reported · Lantana, TXSale reportedBuilt 1978 · S/N 375-78N28923Brown Robert · Rye, NHBuilt 1978 · S/N AA5B0890N28926Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881233N28927Platt Jeremie Aaron · Rich Hill, MOBuilt 1978 · S/N AA5B0894N28929Ramsay Farms And Elevator · Rockville, INS/N AA5B0895N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363N2892FSpeedtape Airways LLC · Williamson, GABuilt 1966 · S/N 18256992N2892RBuenafe Constance Ann · Santa Fe, NMBuilt 1967 · S/N 18258492N2892TScherman Dale M · Ottertail, MNBuilt 1972 · S/N 28-7225272N2892ZDykema Richard H · Soldotna, AKBuilt 1959 · S/N 18-7075N28930Mayer Steven T · Aurora, ORBuilt 1978 · S/N AA5B0896N28933Lewis Group Properties LLC · Apex, NCBuilt 1979 · S/N 32-7940123N28935Kremer Brian F · Iona, MNBuilt 1979 · S/N 32-7940124N2893DAshurst Brent H · Westmorland, CABuilt 1951 · S/N 2242BN2893EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271364N2893MRls Rental Co Inc DBA · Joplin, MOBuilt 1977 · S/N 28-7816321N2893POaero LLC · Boise, IDBuilt 1955 · S/N 18-4491N2893XOlson Philip D · Garden Plain, KSBuilt 1967 · S/N 17700293N28948Badowski Eric W · Plano, TXBuilt 1978 · S/N AA5B0902N28949Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881257N2894MHernandez Michael A · Stockton, CABuilt 1977 · S/N 28-7816322N2894PHolmes Dallas Wade · Bend, ORBuilt 1955 · S/N 18-4492N2894QFerkin Mark A · Caldwell, IDBuilt 1971 · S/N 17259894N2894WDavenport Skyler R · Granbury, TXBuilt 1973 · S/N D-9514N2894ZRs Specialties LLC · Anchorage, AKBuilt 1959 · S/N 18-7078N28950Fischer Andrea D · Belleville, KSBuilt 1978 · S/N AA5B0903N28957Western States Holdings LLC · Sheridan, WYBuilt 1987 · S/N 1016N28958Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881258N28959Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2019 · S/N 2881259N2895AAirspace Aerial Media LLC · Saint Louis, MOBuilt 1953 · S/N 30095N2895FWilson Paul D · Peachtree Corners, GABuilt 1966 · S/N 18256995N2895GWilkins Ranch Inc · Marsland, NEBuilt 1967 · S/N 175N2895PDawes Donald E · College Place, WABuilt 1955 · S/N 18-4493N2895QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259895N2895RCarlson Aaron J · La Villa, TXBuilt 1987 · S/N 1015N2895TSr Patel LLC · Meadville, PABuilt 1972 · S/N 28R-7235156N2895WN2895w LLC · Mount Airy, MDBuilt 1973 · S/N E-457N2895XBoydn2895x LLC · Santa Cruz, CABuilt 1967 · S/N 17700295
Back to AD 2007-04-19 R1