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.

N2187GRegistered aircraftBuilt 1958 · S/N 51487N2187TRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1971 · S/N 28-7205039N2187UFearneyhough Jack M · Gilbertsville, KYBuilt 1979 · S/N 32-7940059N21883Stevenson Flying Service LLC · Selden, KSBuilt 1972 · S/N 18801098N21887Gilheany Robert V · Hicksville, NYBuilt 1974 · S/N 17264039N2188GDisastermarks LLC · Miami, FLBuilt 1958 · S/N 51488N2188RN2188r LLC · Pittsburgh, PABuilt 1969 · S/N 28-5481N2188WMccrea Justin M · Big Spring, TXS/N MC-258N2188ZAlbright Duane C · Wasilla, AKBuilt 1963 · S/N 18051288N21893Western Territory Flyers LLC · Fairfax, CABuilt 1974 · S/N 17264040N2189QBlue Hen Aviation Services LLC · Easton, PABuilt 1979 · S/N 28-7990298N2189RSchrage James A · Danville, INBuilt 1969 · S/N 28-5482N2189TTulsa Aviation Group Leasing LLC · Claremore, OKBuilt 1971 · S/N 28-7205041N2189WJohnson Jay W · Wichita, KSBuilt 1976 · S/N M-1892N2189ZWeltin Gregory G · Kennebunk, MEBuilt 1981 · S/N 28-8190285N218CCSotally Tober LLC · Wilmington, DEBuilt 1979 · S/N 21063297N218CDRegistered aircraftBuilt 2001 · S/N 1123N218CFLevel 200 LLC · Charlottesville, VABuilt 1980 · S/N 340A0989N218CGCourtney Melissa · San Diego, CABuilt 1980 · S/N E-1741N218CPPlumb J Charles · Westlake Village, CABuilt 1997 · S/N 635N218DEFrysinger Investments LLC · Hudson Oaks, TXBuilt 2000 · S/N 18280733N218EABauer Todd A · Kenmare, NDBuilt 1970 · S/N 17259583N218EWHartwig Aerial Spraying Inc · Edgeley, NDBuilt 1961 · S/N TD-466N218FRohler Darryl Richard · Ogden, UTBuilt 1990 · S/N 21204N218KAR3 Aviation LLC · Miami Lakes, FLBuilt 2009 · S/N TH-2267N218KKSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496153N218LBauer George W · Windermere, FLS/N 68N218LKKowalski Leo J · Whitehall, PABuilt 2019 · S/N 25585N218LMKrause Cody · Clear Lake, SDBuilt 2003 · S/N 0501N218MMN218mm LLC · Portland, ORBuilt 1964 · S/N 2825N218MPSupair Ltd · Mooresboro, NCBuilt 2008 · S/N 352N218PM218pm LLC · Fort Collins, COBuilt 2002 · S/N 0201N218PPSumrell James E III · Bumpass, VABuilt 1976 · S/N 172-67520N218RARozo Jhon B · Orlando, FLBuilt 1975 · S/N 17265450N218RBStewart Lawrence D · Council Bluffs, IABuilt 1990 · S/N 623N218SRegistered aircraftBuilt 2018 · S/N 90187N218TBJeffers Billy R · Southside, ALBuilt 1982 · S/N 218N218TCCone Timothy E · Fresno, CABuilt 2007 · S/N TC 82071N218TSAeronautica LLC · West Hollywood, CABuilt 1966 · S/N 28-3675N218USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 310Q0507N218VGreen Gary E · Cotter, ARBuilt 2006 · S/N 45N218WSeaplane Adventures LLC · Cheyenne, WYS/N 18255649N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345N218WLN218wl LLC · Marshalltown, IABuilt 2004 · S/N 40.387N218WSOrourke Brendan W · Stoughton, WIBuilt 1979 · S/N 28-8090094N218XBulzan Lawrence Mitchell · Concord Township, OHBuilt 2004 · S/N 1134N2190FSachs Peter T · Naperville, ILBuilt 1965 · S/N U206-0390N2190GScapegoat Aviation LLC · Choteau, MTBuilt 1958 · S/N 51490N2190LSedine Aaron J · Cedar Springs, MIBuilt 1976 · S/N E-909N2190PN2190p LLC · Titusville, FLS/N 23-799
Back to AD 2007-04-19 R1