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.

N400GEFreeway Airport Inc · Mitchellville, MDBuilt 1981 · S/N 17275445N400GFLively Joshua · Montague, MABuilt 1985 · S/N 32R-8613002N400GMN400gm LLC · Salisbury, MDBuilt 1974 · S/N 310Q1000N400GTDelaney Holdings LLC · De Witt, IABuilt 1971 · S/N 21059544N400HA15 Corp · Lansing, MIBuilt 1970 · S/N 17701484N400HDSpitzer Helicopter LLC · Wilmington, DEBuilt 2008 · S/N 12220N400HG5sfcapital Holdings LLC · Newark, DEBuilt 2026 · S/N 1400N400HVReilly Herbert V · Bloomingburg, NYBuilt 2006 · S/N 400N400HWHotel Whiskey LLC · Sylvania, OHBuilt 1994 · S/N 739-95N400HXTevis David James · Colorado Springs, COBuilt 1964 · S/N 21058352N400JCRegistered aircraftBuilt 1965 · S/N 28-2121N400JGParsons David E · Panama City Beach, FLBuilt 1969 · S/N 17701347N400JRAirspeed Investments LLC · Springfield, TNBuilt 1982 · S/N 28-8316007N400JSKing Canyon Buffalo Inc · Denver, COBuilt 1996 · S/N 1328N400JWAirfleet Holdings LLC · Beverly Hills, CABuilt 1974 · S/N 28-7405276N400KClydesdale Asset Management LLC · Park City, UTBuilt 1979 · S/N 18503889N400KBArrowhead Circle Leasing LLC · Cedar City, UTBuilt 1997 · S/N 1234-97N400LDreher Steve · Bettendorf, IABuilt 1967 · S/N 17700278N400LBAutumn Crocus LLC · Cincinnati, OHS/N 30-1059N400LFBoboltz Randy · Hector, MNBuilt 1975 · S/N D-9825N400LLMentor Flyers Inc · Paragon, INBuilt 1957 · S/N BG-400N400LMGoldberg Gary S · Rockville, MDBuilt 1991 · S/N 10061N400MAPetersen Jacob R · Wasilla, AKBuilt 1978 · S/N 18-7809126N400MERegistered aircraftBuilt 1999 · S/N 30-0040N400MJHaney Michael W · Tehachapi, CAS/N 23-1627N400MTSpevco Inc · Pfafftown, NCBuilt 1955 · S/N G-145N400NEKisska Michael K · Long Beach, CABuilt 2003 · S/N 0040N400PBonanza V35 LLC · Bakersfield, CABuilt 1976 · S/N D-9933N400PFH Richardson & Sons LLC · Ogdensburg, NYBuilt 2015 · S/N 13847N400RCSpiwak Andrew J · Canyon Lake, TXBuilt 1972 · S/N D-9312N400RNGuirguis Samuel · Fort Myers, FLS/N US001N400RUBell Jake T · Lexington, KYBuilt 2008 · S/N 2405N400SDLeonard Tyler D · Newbury Park, CABuilt 1996 · S/N 3612N400TDHardy Mikel · Twin Falls, IDBuilt 1968 · S/N 30-1708N400TVA & A Farms Inc · Arbuckle, CABuilt 2004 · S/N 42041N400UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020228N400UHUhi Inc · Provo, UTBuilt 2014 · S/N 13650N400VHalford John · Ballinger, TXBuilt 1973 · S/N D-9535N400VVCarver Aero LLC · Muscatine, IABuilt 2001 · S/N 4496105N400VWSpuza Dan D · Sanger, TXBuilt 1992 · S/N 681-92N400WOzment Dennis W · Palmyra, MOBuilt 1956 · S/N 35226N400WEOberti Gary A · Hillsborough, CABuilt 1975 · S/N D-9814N400WHHorrigan William Jr · Roxbury, CTBuilt 2001 · S/N 875-2001N400WMBryan Craig · Ellisville, MSBuilt 1972 · S/N 310Q0634N400WRBrown Jon R · Palm City, FLS/N 1N400WTArtspret Aviation LLC · Sugar Grove, ILBuilt 2001 · S/N EA-690N400YCTuca 27 LLC · Lewes, DES/N G-128N4010ARegistered aircraftBuilt 1970 · S/N D-9099N4010BEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1418MN4010YRegistered aircraftBuilt 2025 · S/N 30103
Back to AD 2007-04-19 R1