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.

N422LMJafari Dadbeh · Edmond, OKBuilt 2001 · S/N 0118N422LSSkyknight LLC · Greeneville, TNBuilt 2011 · S/N 172S11117N422LTSr Flyers LLC · Baltimore, MDBuilt 2003 · S/N 0730N422MHHood Helicopters LLC · Wilmington, DEBuilt 2003 · S/N 3418N422MMBolt Robert S · Tampa, FLBuilt 1998 · S/N E-3217N422MTMissouri Dept Of Transportation · Jefferson City, MOBuilt 2008 · S/N 18282051N422NPGarvin Honi J Trustee · Monument, COBuilt 2007 · S/N 23103CN422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LABuilt 1979 · S/N U20605347N422RMMoore Aviation Inc · Beaver Falls, PAS/N 2843526N422RVMachin Geoffrey C · Friday Harbor, WABuilt 1998 · S/N 21422N422SHelfrick Jr Edward W · Elysburg, PABuilt 2006 · S/N 2059N422SCAg Air Squadron One LLC · Saint Joseph, ILBuilt 1967 · S/N 28R-30022N422SHSig Aero LLC · Lewes, DEBuilt 2019 · S/N 18283090N422SPCrosby Scott · Mauldin, SCBuilt 1978 · S/N 18266299N422SSInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 29-0339N422SWLarson Daniel · Mora, MNBuilt 1977 · S/N 21062164N422TSFront Range Heli Inc · Erie, COBuilt 2006 · S/N 11494N422TTTravland Christopher L · Austin, TXBuilt 1978 · S/N R18200221N422USParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020125N422V5lg LLC · Cartersville, GABuilt 1965 · S/N CD-980N422WCWilliams Wade M · Wasilla, AKBuilt 2020 · S/N 001N422WFRoberts Wayne T · Spring Lake, MIBuilt 1946 · S/N 12-2520N422WGWilliams Sara J · Kendallville, INBuilt 1980 · S/N 28-8016341N422WHAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2000 · S/N 0795N423Shafer Robert T · Grosse Ile, MIBuilt 1978 · S/N AA5B0986N42300James Douglas M Trustee · Scottsdale, AZBuilt 1968 · S/N 18258952N42304Ratcliff John · Rincon, GABuilt 1968 · S/N 18258954N42305Registered aircraftBuilt 1973 · S/N 18052339N42306Wright Nolene L Trustee · Wright, WYBuilt 1968 · S/N 18258956N4230HHonolulu Helicopter Tours Inc · Honolulu, HIBuilt 2013 · S/N 2323N4230JPleasant Valley Aviation Inc · Bellefonte, PABuilt 1966 · S/N 28-22579N4230QAir Castles LLC · Ozark, ALBuilt 1971 · S/N 17260130N4230ZBishop Mike · Rifle, COBuilt 1966 · S/N 18-8456N42311Murphy Kenneth E · Pahrump, NVBuilt 1968 · S/N 18258959N42312Swinehart Frank E · Lock Haven, PABuilt 1995 · S/N 773N42313Altitude Enterprises LLC · Omaha, NEBuilt 1968 · S/N 18258961N42314Mackenzie Jeffrey S · Woodland, MIBuilt 1968 · S/N 18258962N42317Meyers Brad C · Reno, TXBuilt 1968 · S/N 18258963N4231JBielusiak Stanley J · Dartmouth, MABuilt 1967 · S/N 28-22580N4231TInternational Air Services Inc Trustee · Carson City, NVS/N 172S12370N42321Olson Richard Allen · Weatherford, TXBuilt 2018 · S/N 3275N42323Gardiner Russell J · Phoenix, AZS/N 18258965N42325Henry Nolan T · Ashland, ORS/N 18258967N42326Hooper James Carl · Webster, MNBuilt 1968 · S/N 18258968N42328High Tony W · Walters, OKBuilt 1968 · S/N 18258969N4232FSekel David A · San Diego, CABuilt 1976 · S/N 28-7725005N4232HHupp Garrett · Sunbury, PABuilt 1978 · S/N 24-0671N4232JN4232j LLC · Waialua, HIS/N 28-22581N4232QRamstad Trygg J · Anchorage, AKS/N 18502227N4232TDgap LLC · Niles, OHBuilt 1971 · S/N 28-7210005
Back to AD 2007-04-19 R1