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.

N526VTN526ma LLC · South Burlington, VTBuilt 1998 · S/N 1411N526WDenney Christopher R · Vicksburg, MSBuilt 1998 · S/N 21967N526WPPickering Gordon D · La Pine, ORBuilt 2020 · S/N 441N526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLS/N 17269371N52700Air Transport Inc DBA · Las Vegas, NVS/N 17274583N52701Cannon Michael A DBA · Blythe, CABuilt 1981 · S/N 17274584N52702Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274585N52704Owen John D Trustee · Liberty, MOBuilt 1974 · S/N 18262782N52707Mook Douglas G · El Paso, TXBuilt 1974 · S/N 18262785N5270DGibson Brenton D · Siletz, ORBuilt 1957 · S/N 50168N5270GLewis University · Romeoville, ILBuilt 2009 · S/N 172S11003N5270HR & D Aircraft Inc · Jamestown, NCBuilt 1975 · S/N 17265390N52712Macmillan Elizabeth A · Franklin, MABuilt 2002 · S/N 172S9192N52714Greager William E · Lakewood, COBuilt 1974 · S/N 18262791N5271LBright Skies Sales And Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-4569N5271RAyala-Moore Kristopher · Tucson, AZBuilt 1974 · S/N 17263485N5271SRegistered aircraftBuilt 1980 · S/N R18201533N5271TOracle Aviation LLC · Omaha, NEBuilt 1972 · S/N 28R-7235212N5271U71 Uniform Corp · The Villages, FLBuilt 1980 · S/N 172RG0316N5271WBrown Thrasher Aero LLC · Midland, GABuilt 1962 · S/N 28-317N5271XRussell Steven N · Anchorage, AKBuilt 1969 · S/N 196N52720Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274592N52726Cottonwood Flyers LLC · Gypsum, COBuilt 1974 · S/N 18262800N52727Nathaniel Mothershead · Sardis, MSBuilt 1974 · S/N 18262801N5272AWelch Kevin R · Hartland, WIBuilt 1961 · S/N 23-2019N5272GEvers Alan D · Huddleston, VABuilt 1957 · S/N 38060N5272NMaddie LLC · Hinton, WVBuilt 2009 · S/N 172S10999N5272PBombach James · Katy, TXBuilt 1958 · S/N 24-311N5272RRichmond Pilots Corp · Linden, NJBuilt 1974 · S/N 17263486N5272UAerial Surveys Inc · Conway, ARBuilt 1964 · S/N 206-0272N52732Registered aircraftBuilt 1974 · S/N 18262804N52735Patzoldt Quenton A · Pine City, MNBuilt 1974 · S/N 18262806N52736Busick Clifford E · Stevenson Ranch, CABuilt 1974 · S/N 18262807N52739Above All Aviation Inc · Santa Barbara, CABuilt 1974 · S/N 18262810N5273AK&M Aviation LLC · West Liberty, KYS/N 35473N5273DDrath Mark O · Reedsville, WIBuilt 1957 · S/N 50171N5273EDaniels Ronald H · Delton, MIBuilt 1959 · S/N 50573N5273FPsc Leasing LLC · Nokesville, VABuilt 2009 · S/N 18282193N5273GBrower Aerial Imaging Inc · Wilmington, DEBuilt 1957 · S/N 38099N5273KColumbia Fire & Safety LLC · Wilmington, DEBuilt 2002 · S/N 18281162N5273LMancuso Dale · Dallas, TXFirst renewal noticeBuilt 1967 · S/N 28-4571N5273PSouthern View Energy Inc · Lula, GABuilt 1958 · S/N 24-312N5273RClear Prop Aviation LLC · Sterling, VABuilt 1974 · S/N 17263487N5273SCarnegie Nursing Home Inc · Carnegie, OKBuilt 1971 · S/N 28-7125209N5273TFunk Michael W · Windham, NHBuilt 1982 · S/N R18201846N5273UKatola LLC · Anaheim, CABuilt 2002 · S/N 172S9193N5273XToledo Jorge A · Miami, FLBuilt 1969 · S/N 175N52746Kravchenko Aleksandr · Everett, WAS/N 18262815N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598N52748Hall Howard S · Covington, GABuilt 1974 · S/N 18262816
Back to AD 2007-04-19 R1