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.

N5521KBrowning Ricou R Jr · Melbourne, FLBuilt 1978 · S/N 386-78N5521PSkyview Aviation Services Inc · Lakeland, FLBuilt 1958 · S/N 24-584N5521QEckmann Sheri L · Santa Barbara, CABuilt 2014 · S/N 172S11422N5521SChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11421N5521UMiller Groom Marie T · Rockford, ILBuilt 1969 · S/N 28-26234N55220Ishii Kanji · Brooklyn, NYBuilt 1973 · S/N 28R-7335195N5522A5522a LLC · Bethany, OKBuilt 2014 · S/N 172S11423N5522BBazerko Family Fun LLC · Caldwell, IDBuilt 1956 · S/N 33522N5522COswald Ron · Eden Prairie, MNBuilt 1986 · S/N 21064973N5522DBrewer Thomas A · Anderson, INBuilt 1957 · S/N D-5057N5522FSchlaffer Sandor · Daytona Beach, FLBuilt 1957 · S/N D-5019N5522KHall Dean A · Hyattsville, MDBuilt 1965 · S/N 601N5522QBarnhill Jerry D · Longville, LABuilt 1965 · S/N 614N5522SAmeriflyers Of Texas Inc · Addison, TXBuilt 2014 · S/N 172S11430N5522TBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1978 · S/N TK-79N5522UAlbrecht Jeffrey N Trustee · Mount Horeb, WIBuilt 1969 · S/N 28-26237N5522XChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11429N55231Golf November Aero LLC · Sunnyvale, CABuilt 2014 · S/N 172S11414N55234Alien Invaders LLC · Medina, WABuilt 2014 · S/N 172S11415N55236Bobnal LLC · Conway, SCBuilt 1981 · S/N 17275139N5523FSirko Frederick S · Portage, INBuilt 1968 · S/N 28-24864N5523PBens Motorworks Inc · Fullerton, CAS/N 24-586N5523QDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11412N5523RPlett John · Anaconda, MTBuilt 1979 · S/N 172RG0069N5523SDj Flight Service LLC · Little Falls, MNBuilt 1966 · S/N 188-0023N5523TCantrup Peter H · White Rock, NMBuilt 1982 · S/N R18201884N5523UKlein Michael · Gilsum, NHBuilt 1969 · S/N 28-26238N5523VDolphin Leasing LLC · Daytona Beach, FLBuilt 2014 · S/N 172S11413N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236N55240General Associated Products Inc · San Lorenzo, CABuilt 1973 · S/N 28-7325349N55242Hills Holding · Newark, DEBuilt 1981 · S/N 17275142N55244Wiechman Herbert · Boulder, COBuilt 1973 · S/N 28-7305340N55246Kadena Aero Club · Apo, APBuilt 1981 · S/N 17275143N55247Nordstrom Terry G · Scottsdale, AZBuilt 1973 · S/N 28R-7335199N5524PSwarm Darryl J · Quincy, CABuilt 1958 · S/N 24-587N5524QImwalle John N · Batavia, OHS/N 615N5524SStellon Eugene A Jr · Burlington, CTBuilt 1980 · S/N R18201594N5524VRamsey Jarrod Ross · Chicago, ILBuilt 1989 · S/N E-2505N5524WHoe David S · Stafford, VABuilt 1962 · S/N 28-614N55250Colorado Aircraft Corp · Watkins, COBuilt 1981 · S/N 17275144N55251Albatross Air Inc · Beaver, WVS/N 28-7305342N55253Mccall Christopher J · Cocoa Beach, FLBuilt 1973 · S/N 28R-7335200N55256Notam Aviation LLC · Portage Des Sioux, MOBuilt 1981 · S/N 17275146N55259Heth Steven L · Westhope, NDBuilt 1973 · S/N 28-7325354N5525DOlsen Gary E · Albuquerque, NMBuilt 1957 · S/N D-5061N5525FCashion Thomas A · Mastic, NYBuilt 1968 · S/N 28-24866N5525JElliott James Richard · Florence, ALBuilt 1967 · S/N 32-984N5525KMacomber Donald Conrad · Santa Ynez, CABuilt 1978 · S/N 1025-78N5525USheriffs Department · Oakland, CABuilt 1979 · S/N U20605311N5525WWells Nicholas · Dallas, TXBuilt 2002 · S/N 02-04-20
Back to AD 2007-04-19 R1