OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N257RVCrews James M · Milan, TNBuilt 2008 · S/N 73086N257SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 32-40755N257SDDanmeier Stephen R · Irving, TXS/N 319RN257SPAviatzone LLC · Fort Lauderdale, FLBuilt 1977 · S/N 20700781N257TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881857N257WDWatts James F · Lone Tree, COBuilt 2022 · S/N 70654N257ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881612N2580GLei Puahi Inc · Klamath Falls, ORBuilt 1959 · S/N 51880N2580RFlight Club Academy LLC · Palmetto Bay, FLBuilt 1969 · S/N 28-5650N2580WLewis Kyle Walker · Trenton, TXBuilt 1965 · S/N 937N2581Humphreys Kenneth G · Moriarty, NMBuilt 1969 · S/N 1N2581FShields Mitchell · Millville, NJBuilt 1965 · S/N 27N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002N2581MSpencer David W · Anchorage, AKBuilt 1947 · S/N 12-1049N2581PWick Melvin D · Palmer, AKBuilt 1955 · S/N 18-4323N2581WClay Shelli V · Savannah, GABuilt 1965 · S/N 938N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003N2582PTriple A Aviation LLC · Plano, TXBuilt 2026 · S/N E-4166N2582Q82q LLC · Glenwood, MDS/N 18257782N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282N2582SHigh Exposure Inc · Wilmington, DEBuilt 1979 · S/N 18-7909161N2582WPetersen Bennett David · Ashland, OHBuilt 1965 · S/N 3277N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004N25830Surette Rosemarie · Vail, COBuilt 1980 · S/N 3779N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883N2583PHudzinski Thomas E · Wasilla, AKBuilt 1955 · S/N 18-4325N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250N2583WRuckel Daniel A · Floyds Knobs, INBuilt 1965 · S/N 3278N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005N2584PZambarano Matthew · South Hero, VTBuilt 1955 · S/N 18-4326N2584SStrouckel Jesse · Roscoe, SDS/N 18-7909162N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285N2585SWright George E · Homestead, FLS/N 18-7909164N2585WClassic Mooney Nv LLC · Henderson, NVBuilt 1965 · S/N 940N2586GJeppesen Thomas L · Stanton, MIS/N 7N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786N2586WVizinat David C · Ragley, LABuilt 1965 · S/N 941N2586XPiper Kffc LLC · Peachtree City, GABuilt 1985 · S/N 28-8690003N2586ZFernandez John III · Cape Canaveral, FLS/N 355-77N2587JCastle Chad · Sunnyside, WABuilt 1979 · S/N 18-7909133N2587WOrourke Timothy L · Laguna Niguel, CABuilt 1965 · S/N 3279N2588MN-J Aviation LLC · Forest, VAS/N 32R-7880066N2588POkonek Kellie L · Girdwood, AKBuilt 1955 · S/N 18-4332N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288N2588WJohnson Mitchell R · Bismarck, NDBuilt 1965 · S/N 3280N2588ZBindon Philip E · Wasilla, AKBuilt 1963 · S/N 185-0588N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889
Back to AD 2007-04-19 R1