OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1616POwen David C · Fort Myers, FLBuilt 1954 · S/N 22-2430N1616RBerck Michael P · Clackamas, ORBuilt 1974 · S/N AA5-0716N1617CRetroair Restoration LLC · Big Lake, AKBuilt 1953 · S/N 30317N1617VCook Timothy D · Ashville, NYBuilt 1974 · S/N 17263694N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491N1618MFluckey Gary T · Homer, AKBuilt 1970 · S/N 18501834N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869N161AMDe Boissard Karen · New York, NYS/N 2161N161AWAir Ward Inc · Columbia, CABuilt 1979 · S/N 28-8016078N161BGWilson James R · Midlothian, VABuilt 1978 · S/N 287816527N161BWWelch William Ben · Danville, ILBuilt 2005 · S/N 10601N161CMR&J Helicopters LLC · Port Byron, ILBuilt 2016 · S/N 2444N161CTEddy Company Inc · Apple Valley, CABuilt 1984 · S/N 18268414N161DFulper Lester D · Clearwater, FLBuilt 2024 · S/N 5745N161DERegistered aircraftBuilt 1977 · S/N 28-7816295N161DSHeffron Neuhold Nicholas A · Honolulu, HIBuilt 1977 · S/N 2136N161EWalsh David E · North Platte, NEBuilt 1956 · S/N 32692N161FCAps Asset Management Inc · Mesa, AZBuilt 2001 · S/N 133N161GLEdwards Jeffrey L · Port Orange, FLBuilt 1978 · S/N 0814N161GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1986 · S/N 17276650N161JHAllison Daniel S Trustee · Jenner, CABuilt 1991 · S/N 5232N161JLLuebben John R · Fayetteville, GABuilt 1966 · S/N 346N161KCCk Aviation LLC · Melbourne, ARBuilt 1980 · S/N E-1700N161KMParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7716136N161LMays Stephen W · Carson City, NVBuilt 1971 · S/N 470N161MBKerf 25 Corp · Wilmington, DEBuilt 1982 · S/N 28-8216163N161MSBaker Weldon J · Lamesa, TXBuilt 2002 · S/N 60469N161PRegistered aircraftBuilt 1958 · S/N 24-533N161PCSpence Jeffrey · Haskell, OKBuilt 2020 · S/N 40052N161PSBond Robert E · Knoxville, TNBuilt 1996 · S/N 5339N161PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841156N161RBower Fredrick S · Watervliet, MIS/N TE-365N161REVornholt David · New Richmond, OHBuilt 1969 · S/N 30-1952N161RMTurbine Screws LLC · Bozeman, MTBuilt 1980 · S/N 414A0450N161RPCrucial LLC · Kalispell, MTBuilt 1982 · S/N 32R-8213049N161RVMatice Brian W · Riverview, FLBuilt 2022 · S/N 74520N161RWMcdonald Walter S · Park City, UTBuilt 2006 · S/N 53MN161SAAviation Consultants Inc DBA · San Luis Obispo, CABuilt 2002 · S/N 901-2002N161SEOquinn Timothy M · Tehachapi, CABuilt 2006 · S/N 1027-2006N161SG3bs Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1000-2005N161SMMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 28-7916508N161SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14731N161SWLober Cameron K · Matthews, NCBuilt 1966 · S/N 28-3752N161TCAkrotown USA LLC · Tualatin, ORS/N 5357N161TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881549N161TRRambo Timothy B · Nampa, IDBuilt 1991 · S/N CE-1619N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719N161WCater Christopher B · Lowell, MIBuilt 1965 · S/N D-7914
Back to AD 2007-04-19 R1