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.

N26829Parr Russell R · Auburn, WABuilt 1978 · S/N AA5A0747N2682AAnacortes Associates LLC · Anacortes, WABuilt 1969 · S/N D-9045N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648N2682GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1959 · S/N 51982N2682RRadeka Michael · East Machias, MES/N 18258382N2682TMorrison James S · Bergen, NYBuilt 1971 · S/N 28-7225086N2682ZEmslie Donis A · West Lafayette, OHBuilt 1978 · S/N 265-78N26830Butcher Alden K · Jane Lew, WVBuilt 1978 · S/N AA5A0748N26831Horn Charles R Jr · Avondale, AZBuilt 1978 · S/N AA5A0749N26839Brown Timothy · Plainfield, INBuilt 1978 · S/N AA5A0756N2683CGrigg Charles G · Pasco, WABuilt 1978 · S/N R18200211N2683GEtc Aircraft LLC · Anchorage, AKFirst renewal noticeS/N 51983N2683RNance James H II · Grants Pass, ORBuilt 1967 · S/N 18258383N2683TSojourn Flyers Inc · Chebanse, ILBuilt 1971 · S/N 28-7205082N2683WSabagh Steve B · Maricopa, AZBuilt 1966 · S/N 1002N26840White Mary · Thurmont, MDS/N AA5A0757N26845Thornton Charles A · Collinsville, ILS/N AA5A0761N26847Anderson Wayne D · Providence Forge, VAS/N AA5A0762N2684FFelts Anthony E · Groveland, CAS/N 18256784N2684QJastram Benjamin C · Lafayette, LABuilt 1966 · S/N 18257884N2684TGallaher Matthew · Anchorage, AKBuilt 1971 · S/N 28-7225087N26850Palm Michael · Middletown, RIBuilt 1978 · S/N AA5A0765N26855Clarke George W · Sierra Vista, AZBuilt 1978 · S/N AA5A0769N2685FBabovic Slobodan · Elm Grove, WIBuilt 1965 · S/N 18256785N2685QMcelmoyl John W · Greenfield, CABuilt 1966 · S/N 18257885N2685XWorden Andrew · Burlington, COS/N 18255311N26860Robinson Andrew T · South Windsor, CTBuilt 1978 · S/N AA5A0773N26868Musser Alvin M Jr · Memphis, MOBuilt 1941 · S/N 4252N2686FKing Cara Jean · Deland, FLBuilt 1965 · S/N 18256786N2686QLines Daniel R · Roseburg, ORBuilt 1966 · S/N 18257886N2686TGoddard John · Penokee, KSBuilt 1971 · S/N 28-7205083N26872Hughes Tool & Die LLC · Norfolk, VABuilt 1978 · S/N AA5A0777N26874Sale Reported · Sacramento, CASale reported, pending cancellationS/N AA5A0778N26875Yin Steve · Del Mar, CABuilt 1978 · S/N AA5A0779N2687FT Air LLC · Columbia Falls, MTBuilt 1965 · S/N 18256787N2687LA R Preston Holdings LLC · Ontario, NYBuilt 1998 · S/N 18280314N2687QKnorr John Lee · Puposky, MNBuilt 1966 · S/N 18257887N2687RSpangler Keith · Monroeville, INBuilt 1967 · S/N 18258387N2687THolley Ronald E · Hastings, MIBuilt 1971 · S/N 28-7205093N2687ZSchaefer Richard T · Marble Falls, TXBuilt 1978 · S/N 365-78N26880Sinclair Ian · Pembroker, NYBuilt 1978 · S/N AA5A0782N26887Patel Ronik M · Pearland, TXS/N AA5A0789N26888Mcguire Eric · Weare, NHBuilt 1979 · S/N AA5A0790N2688BScott Fred · Greencastle, INBuilt 1968 · S/N 28-5065N2688DB2 Air LLC · Pierre, SDBuilt 1979 · S/N 414A0332N2688FWagosh Aviation LLC · Flagstaff, AZBuilt 1965 · S/N 18256788N2688MAlcyone Trust Corp Trustee · Wichita, KSBuilt 1979 · S/N 414A0334N2688RShaw Thomas B · Hobbs, NMBuilt 1967 · S/N 18258388N2688XDw Hamm Consulting LLC · Malibu, CABuilt 1979 · S/N 414A0336N26894Moore Altitude LLC · Lake Saint Louis, MOBuilt 1979 · S/N AA5A0795
Back to AD 2007-04-19 R1