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.

N3181SWood David M · Purcellville, VABuilt 1964 · S/N 18255681N3181TDuck Donald S · Edwardsburg, MIBuilt 1967 · S/N 17700481N3181UBig Sky Aviation LLC · Ridgeland, MSBuilt 1994 · S/N EA-563N3181WNormark Jordan C · Granbury, TXBuilt 1974 · S/N D-9575N3182DHanft Thomas A · Oakhurst, CABuilt 1955 · S/N 31980N3182LN303cj LLC #1 · Lexington, KYBuilt 1999 · S/N TH1882N3182QMagnusson Ralph L · Wyoming, MNBuilt 1967 · S/N 18258182N3182RSeven Hills Sky Divers Inc · Madison, WIBuilt 1967 · S/N 18258582N3182SRyan Aviation Management LLC · Palm Coast, FLBuilt 1964 · S/N 18255646N3182UGarcia-Martinez Jose Victor · Birmingham, ALBuilt 1963 · S/N 18254582N3182WOutstate Air Taxi Inc · Windom, MNBuilt 1974 · S/N CE-482N3182YHeckethorn Philipp · Baker, NVBuilt 1962 · S/N 18254182N3182ZArnt Aerial Spraying Inc · Worthington, MNBuilt 1959 · S/N 18-7173N31831Dcoat LLC · Greenlawn, NYBuilt 1978 · S/N 28-7890479N3183CWide Open Aviation LLC · Kennewick, WABuilt 1978 · S/N R18200251N3183DT2k Aircraft · Austin, TXBuilt 1955 · S/N 31981N3183L4 All In Inc · North Fort Myers, FLBuilt 1965 · S/N 310J0183N3183QMj Syndicate LLC · Vancouver, WAS/N 18258183N3183RRusso Anthony G · Melbourne Beach, FLS/N 18258583N3183SJohnson Richard · Winnebago, MNBuilt 1964 · S/N 18255683N3183YAlc Aviation LLC · Milwaukee, WIBuilt 1962 · S/N 18254183N3183ZPancoast John M · Palmer, AKBuilt 1959 · S/N 18-7174N31841Rotormate LLC · Royse City, TXBuilt 1978 · S/N 32-7840149N3184DRitchie Rex W · Lopez Island, WABuilt 1955 · S/N 31982N3184LKimbrell Heath · Quinlan, TXS/N 310J0184N3184QBeaugh Anthony H · Platteville, COBuilt 1967 · S/N 18258184N3184RGardner Daniel J · Alvord, TXBuilt 1967 · S/N 18258584N3184SThrash Farms Inc · Pelahatchie, MSBuilt 1964 · S/N 18255684N3184TMetroplex Flight Services LLC · Fort Worth, TXBuilt 2006 · S/N 11562N3184YFunkhouser David E · Weatherford, OKBuilt 1962 · S/N 18254184N3185CThree Pipers Piping LLC · Charleston, SCBuilt 2000 · S/N E-3324N3185DMorgan Douglas C · Anchorage, AKBuilt 1955 · S/N 31983N3185F85 Foxtrot LLC · Redmond, ORS/N 18257285N3185QPara Tactics LLC · Shelton, WABuilt 1967 · S/N 18258185N3185YGochenour Air Inc · Fort Wayne, INBuilt 1962 · S/N 18254185N3186Shettel Jay E II · Carlisle, PABuilt 1970 · S/N HH-1N31863Dell Air Co LLC · Paterson, NJBuilt 1978 · S/N 28-7890482N31865Hartwig Flying Service LLC · Eagle River, WIBuilt 1995 · S/N 17003CN31868Yarger Dylan C · Anchorage, AKBuilt 1995 · S/N 19040CN3186DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 31984N3186QKimbril Steve · Hartselle, ALBuilt 1967 · S/N 18258186N3186RHuey Gale R · Celeste, TXBuilt 1967 · S/N 18258586N3186YJram Air Parts LLC · Henderson, NVBuilt 1962 · S/N 18254186N31871Dodson Randall L · New Hope, MNBuilt 1978 · S/N 32-7840150N3187CHemm Colby L · Newcastle, CABuilt 1954 · S/N 30986N3187FVolatile Aero Ventures LLC · Boulder City, NVBuilt 1966 · S/N 18257287N3187HDike Randall K · Owensville, INBuilt 1995 · S/N 23018CN3187PAir Over Ground LLC · Helena, MTS/N 23-1124N3187QJuliet Whiskey Aviation LLC · Gilbert, AZBuilt 1977 · S/N 28-7790441N3187SWinberg Tanner · Dorchester, NES/N 14070C
Back to AD 2007-04-19 R1