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.

N54223Woodworth Brent J · Halliday, NDBuilt 1976 · S/N 18-7609045N5422BR & R Aviation LLC · Arnaudville, LABuilt 1956 · S/N 33422N5422DJohnson Benjamin Keith · Dayton, OHBuilt 1957 · S/N D-4937N5422QMandeville James R · Bridgewater, MABuilt 1989 · S/N 111N5422SVanwagnen Brian J · Jackson, MIBuilt 1971 · S/N 28-7125118N5422URegistration Pending · Livermore, CORegistration pendingBuilt 1967 · S/N TE-407N54233Wenke Donald S · Big Lake, AKBuilt 1976 · S/N 18-7609047N5423BBeck Skydiving & Rigging LLC · Bixby, OKBuilt 1956 · S/N 33423N5423ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271854N5423JRialto Christian Flyers Club Inc · Bradenton, FLBuilt 1980 · S/N 17273787N5423KRandel James B III · Mill Valley, CABuilt 1980 · S/N 17274105N5423PPapp Frank J · Fort Mohave, AZBuilt 1959 · S/N 24-477N54247Registration Pending · Melbourne, FLRegistration pendingBuilt 1976 · S/N 18-7609049N5424AFudurich David E · Goleta, CABuilt 1979 · S/N 21063428N5424JFusano Lisa A · La Crescenta, CABuilt 1980 · S/N 17273788N5424PHerreid William L Jr · Prairie Du Chien, WIBuilt 1958 · S/N 24-478N5424QBeltzville Aero LLC · Lehighton, PABuilt 1973 · S/N 17261787N5424SNeely Benson W · Florence, MSBuilt 1971 · S/N 28-7125119N5424UWsol Michael P DBA · Huntington Beach, CABuilt 1979 · S/N U20605287N5424VSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 172RG0528N54251Inverted Aviation LLC · Belleair, FLBuilt 1956 · S/N BG-251N54257Meridian Airport Authority · Meridian, MSBuilt 1981 · S/N 17274932N5425AValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N 21063429N5425BEslinger Beau T · Tucson, AZBuilt 1956 · S/N 33425N5425LHamilton Paul DBA · Fresno, TXBuilt 1973 · S/N AA5-0325N5425MWong Alex · Hillsborough, CABuilt 1978 · S/N M-2026N5425SBunn James W · New Port Richey, FLBuilt 1980 · S/N R18201570N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497N5425YWilson Leif L · Tok, AKBuilt 1964 · S/N 18-8177N5426Vieira Mark · Turlock, CABuilt 2014 · S/N 1001N54266Low Country Skyways LLC · Wilmington, DEBuilt 1989 · S/N 5-18-42N5426CVirginia Air Inc · Roanoke, VABuilt 1979 · S/N 21063749N5426FPressley Aviation LLC · New London, NCBuilt 1976 · S/N 28-7715132N5426JMedia Stew LLC · Carson City, NVS/N 17273789N5426MWorthington Aras · Anchorage, AKS/N 001N5426PTromble Tim L · Story, WYBuilt 1958 · S/N 24-480N5426QLen Emery Photography LLC · Springfield, VTBuilt 1973 · S/N 17261789N54273Swanson Gary A · Fort Bragg, CABuilt 1981 · S/N 17274938N5427BYeary Clifton K · Quitaque, TXBuilt 1956 · S/N 33427N5427FRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 28-7715133N5427XRegistered aircraftBuilt 1980 · S/N U20605743N54283Sale Reported · Lewistown, MTSale reportedBuilt 1975 · S/N 18-7509130N54285Monahan Richard J Jr · Budd Lake, NJBuilt 1981 · S/N 17274945N54288Chandler Air Service Inc · Chandler, AZBuilt 1981 · S/N 17274946N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118N5428UCordova Air Service Inc · Cordova, AKBuilt 1979 · S/N U20605290N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500N54290Laguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 17274948N54291Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17274949N54296Honcho Aircraft LLC · Crosby, TXBuilt 1981 · S/N 17274950
Back to AD 2007-04-19 R1