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.

N55DACircle L J Aviation Inc · Plant City, FLBuilt 1951 · S/N C1-0319N55DBFletcher William J Trustee · Carson City, NVBuilt 1969 · S/N TE-716N55DHAcmed Consulting LLC · Bradford, RIBuilt 1997 · S/N 24-3414N55DKUrbina Mario Antonio · Pacoima, CABuilt 1959 · S/N 35878N55DLHill Brock E · Palouse, WABuilt 1955 · S/N 31362N55DPMagaw David N · Sacramento, CABuilt 1974 · S/N DP-3N55DYBrown Carl A · Las Cruces, NMBuilt 1992 · S/N 194N55DZHuey Christopher D · Mesa, AZS/N 9472004N55EKMengel David M · Monticello, INS/N 1568N55ELLynn Edward Wayne · Vancouver, WABuilt 2019 · S/N 25237N55EMIxi LLC · West Bloomfield, MIBuilt 1974 · S/N 28-7415328N55EWHanratty Brian James · Pismo Beach, CABuilt 1966 · S/N TD-681N55EZSummit Aviation Resources LLC · Akron, OHBuilt 1970 · S/N TE-785N55FDDieu Est Mon Courage LLC · Fernandina Beach, FLBuilt 1975 · S/N TC-1857N55FFSiedschlag Paul C · Granbury, TXBuilt 1978 · S/N 24-0672N55GASaathoff Michael A · Stockton, MOS/N 541N55GBRivers Paul E · Shannon, ILBuilt 1979 · S/N 212056N55GGAll Attitude Aviation Inc · Edgewater, FLBuilt 1985 · S/N 1030N55GTTurner William Hugh Vi · Belmont, CABuilt 1979 · S/N 5N55HAHonaker Group LLC · Sellersburg, INS/N 17269194N55HHWeir William K · Boylston, MABuilt 1965 · S/N CD-945N55HJRadlinger Joseph · Hudson, WIBuilt 1977 · S/N 18265736N55HMMoore Brian L · Reno, NVBuilt 1974 · S/N TC-1723N55HNNaylor John H · Conway, ARS/N ONEN55HQHerndon Colton R · Smithville, MOBuilt 1965 · S/N 743N55HUKaihai Corp · Wilmington, DEBuilt 1999 · S/N 2046N55HVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 12641N55HYBlackdog Holding Inc · Pleasant Valley, NYBuilt 2013 · S/N 3200N55JAOberman Mark · Camarillo, CABuilt 1971 · S/N 295N55JBHigh Point Management Co · Graford, TXBuilt 1990 · S/N CE-1493N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55JJPrivitt Bret · Fort Worth, TXBuilt 1974 · S/N 311-75N55JUDakota & Skyy LLC · Louisville, COBuilt 2019 · S/N E-4131N55KMbi · Indn Hbr Bch, FLBuilt 1979 · S/N E-1601N55KAEvans Dick Trustee · Riverside, CAS/N 18052987N55KCBloch Jeremy · San Francisco, CABuilt 1976 · S/N D-9930N55KEMiller Charles A · Walla Walla, WABuilt 1990 · S/N 20081N55KHDietle Kurt · Valley Springs, CABuilt 1979 · S/N R18201104N55KLNewman John D · Clyo, GAS/N 968-1N55KMHeberling Michael J · Fort Worth, TXBuilt 2006 · S/N 40178N55KPJm Waypoint LLC · Fresno, CABuilt 1970 · S/N D-9173N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344N55KSPerlan LLC · Melbourne, FLBuilt 2003 · S/N 0550N55LDDouble R Airways LLC · Largo, FLBuilt 1998 · S/N 3246101N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55LPAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0401N55LTRegistration Pending · Tucson, AZRegistration pendingS/N 414-0926N55LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12063N55LWLeeward Aero Sales Corp · Ocala, FLS/N 1851185N55MAGodwin Gerald R · Kountze, TXBuilt 2005 · S/N 2316
Back to AD 2007-04-19 R1