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.

N3775FHickle William H · Inyokern, CABuilt 1977 · S/N 0766N3775PClayton Patrick D · Hazen, ARBuilt 1955 · S/N 18-4663N3775RBack Mark D · Washington, DCBuilt 1970 · S/N 28-5818N3776USchmit Joe · Ventura, IAS/N 18255176N3776XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1968 · S/N 270N3777DOrchid Aero LLC · Lakewood, COS/N 34477N3777LCowboy Aviation Services LLC · Polson, MTBuilt 2001 · S/N 3RX013N3777PSkatvold Charles P · Moorhead, MNBuilt 1959 · S/N 18-4665N3777SStuart Guy · Owosso, MIBuilt 2000 · S/N E-3351N3777TStewart Donald J · Palm City, FLBuilt 1967 · S/N 28R-30089N3777ZAnderson Clarence Trustee · Anchorage, AKS/N 18-7459N3778DBrownd Carl L · Oro Valley, AZBuilt 1957 · S/N 34478N3778TVan De Vanter Robert A · Paso Robles, CAS/N 28R-30090N3778UBlue Goose Aviation Inc · Polson, MTBuilt 1964 · S/N 18255178N3778XChang Tim C · Ocala, FLFirst renewal noticeBuilt 1968 · S/N 271N3778YTime Air LLC · Mendon, UTBuilt 1965 · S/N T210-0034N3778ZWard Nelson H · Salcha, AKBuilt 1960 · S/N 18-7460N37790Cottrell Mark C · Leitchfield, KYBuilt 1982 · S/N RHM-1N3779DSeattle Glider Council Inc · Bellevue, WABuilt 1957 · S/N 34479N3779NObrien Edward Trustee · Walnut Creek, CAS/N 680116N3779QLegge John D · Cleveland, OHBuilt 1967 · S/N CD-1072N3779TShultz Martin · Naperville, ILBuilt 1967 · S/N 28R-30091N3779UWhittom Ronald W Jr · Wasilla, AKBuilt 1963 · S/N 18255179N3779WAirmotive Service LLC · Brigham City, UTBuilt 1966 · S/N 32-701N3779YJoiner Matthew A · Temple, GABuilt 1963 · S/N 21058279N3779ZNace Kris A · Glendale, ORBuilt 1960 · S/N 18-7461N377AMJohnstone Inc · Wilsonville, ORS/N E-63N377BFountain Acquisitions LLC · Mount Vernon, GAS/N TD-69N377BMQuebec Helicopter LLC · Rehoboth Beach, DEBuilt 1991 · S/N 1691MN377CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283308N377CBBradley Charles A · Gibsonia, PAS/N 24980N377CDAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1022N377CEMetal Mistress Aviation LLC · Meadowview, VABuilt 1976 · S/N 310R0631N377CFCohen Rolando S · New York, NYBuilt 1974 · S/N 20700275N377CPHodgson Jeffrey R · Watsonville, CAFirst renewal noticeBuilt 2010 · S/N 70377N377CZKramer Dean E · Bernville, PABuilt 1960 · S/N 18-7448N377DShawn Wyatt Enterprises Inc · Huntsville, TXBuilt 1983 · S/N E-2087N377DSSeward Bernard L Jr · Charlottesville, VABuilt 2003 · S/N 40.277N377EBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 20608182N377ESEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1997 · S/N 17280086N377GGemini Southern LLC · Orlando, FLBuilt 1969 · S/N TC-1276N377HGHunt James J · Dalton, PABuilt 1998 · S/N 1252-98N377HHJennings Christopher Wyckoff Trustee · Brentwood, TNBuilt 1970 · S/N 39-13N377JDStyer David · Milton Freewater, ORS/N 2007N377JS270 Aviation LLC · Elizabethtown, KYBuilt 1979 · S/N 340A0672N377KCEagle Flying Club LLC · Enid, OKBuilt 1977 · S/N E-1032N377KGGardetto Paul R · Oconomowoc, WIBuilt 2014 · S/N 73266N377LLLawson Larry · Palmer, AKBuilt 2009 · S/N CC18-0040N377LMOliver Gerald D III · Midlothian, TXBuilt 2008 · S/N 648N377RCAncona Air LLC · Wixom, MIBuilt 1978 · S/N 61P05757963251
Back to AD 2007-04-19 R1