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.

N333RJAddco Aviation Services Inc · Newcastle, OKBuilt 1978 · S/N D10188N333RPBordelon Greg M · Houston, TXBuilt 1996 · S/N MII-1466N333RVJones Guy L · Albuquerque, NMBuilt 1980 · S/N 219N333RZJj Magic LLC · Wilmington, DEBuilt 2003 · S/N 10167N333SBSmythe John J III · Rch Palos Vrd, CAS/N 502HN333SEParis Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7350091N333SHVitez David D · Morgantown, WVBuilt 1969 · S/N 15070617N333SJDonald Robert Ferguson · Billings, MTBuilt 1974 · S/N 18502614N333SNHub City Aviation Academy LLC · Lubbock, TXBuilt 1966 · S/N 30-982N333SPBelote David Eldon Trustee · Elbert, COBuilt 1975 · S/N 17702265N333SRRocky Mountain High Aviation LLC · Boulder, COBuilt 1977 · S/N TJ-114N333TKayair LLC · Visalia, CABuilt 1996 · S/N TH-1779N333TFBluebird Airways Inc · East Palatka, FLBuilt 1975 · S/N CE-553N333THUchiyamada Brian N · San Gabriel, CABuilt 1977 · S/N CE-692N333TMSkywagon Aero LLC · Wilmington, DEBuilt 1971 · S/N 18-8939N333TRBreaking Wind LLC · Alabaster, ALBuilt 1979 · S/N CE-860N333TSAerostar Management Services LLC · Kissimmee, FLBuilt 1999 · S/N 172S8240N333UDSpecialty Aero LLC · Seattle, WABuilt 1981 · S/N 340A1256N333UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2013 · S/N 13626N333VAXrrx Inc · Wilmington, DEBuilt 1978 · S/N 27-7854099N333VRSpruce Home + Closet LLC · Southlake, TXBuilt 2016 · S/N 41228N333VWHelderman Laban W · Newton, NCBuilt 1956 · S/N 33952N333WDanarich LLC · Rancho Mirage, CABuilt 1979 · S/N TE-1172N333WAPowell Jay · Columbia, MSBuilt 1969 · S/N E-176N333WDWoelbing Aviation LLC · Franksville, WIBuilt 1966 · S/N 310L-0002N333WHHarris Robert W · Covington, TNBuilt 1986 · S/N 333N333WPPhillips William R · Cullman, ALBuilt 2022 · S/N 80239N333WSMuller Gabriel J · Leesburg, VABuilt 2004 · S/N 0906N333WYJrm Wings LLC · Farmington, UTS/N 30-1800N333XJpg Aviation LLC · Wilmington, DEBuilt 1966 · S/N TE-266N333YZeller Ty F · Trego, WIBuilt 1969 · S/N 7GCBC-194N333YFEagle Aviation LLC · Delray Beach, FLBuilt 1978 · S/N R18200747N333YTRegistered aircraftBuilt 1968 · S/N 18258912N333ZMMuzzio Lewis · Chandler, AZBuilt 2022 · S/N 83607N333ZVWalker Wilber D III · Beeville, TXBuilt 1977 · S/N 18265835N333ZXMallick Aviation Services LLC · Wilmington, DEBuilt 1995 · S/N TH-1739N334Jeffrey Mark · Clayton, MIBuilt 1967 · S/N D-8467N33404Marrero Jeffrey Tomas · Gainesville, FLBuilt 1975 · S/N 28-7515302N33405Appoloney Robert · Walnut, CABuilt 1975 · S/N 28-7515335N33408Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 32-7500021N3340RFrieze Rex · Fair Play, MOBuilt 1967 · S/N 18258640N3340SRegistration Pending · Wilmington, DERegistration pendingBuilt 1969 · S/N 21059140N3340UGingerich Fred D · Heron, MTBuilt 1963 · S/N 18254740N3340XVito Bavaro Construction Inc · Escalon, CAS/N 310L-0190N3340YMckinney Sandra C · Williamsburg, OHBuilt 1962 · S/N 18254340N33417Mercer Aviation Group LLC · Mercer Island, WABuilt 1975 · S/N 28-7515336N3341DTwenty One Miles LLC · Woodland Hills, CABuilt 1955 · S/N 32139N3341FLani Lea Sky Tours LLC · Honolulu, HIBuilt 1966 · S/N 18257341N3341LSky Chem LLC · Downingtown, PABuilt 1976 · S/N MC-462N3341PDahl Troy M · Cedar Rapids, IABuilt 1958 · S/N 23-1294
Back to AD 2007-04-19 R1