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.

N4315VCustom Services Group Inc · Fort Walton Beach, FLBuilt 1983 · S/N 28-8390088N4315YThree Wing Flight School LLC · Stratford, CTBuilt 1983 · S/N 28-8390089N43160Dodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 28-8390090N43164Jasper Thomas Wesley · Monroe, NCBuilt 1974 · S/N 28-7425340N4316AHvizdak George D · Colliers, WVBuilt 1956 · S/N 22-3668N4316HEvans William H Jr · Gardendale, TXBuilt 1951 · S/N 18-880N4316JAnderson Richard E · Indianapolis, INBuilt 1967 · S/N 28-22690N4316RMarston Charles T · New Bern, NCBuilt 1974 · S/N 17263069N4316USkyborne Airline Academy Inc · Vero Beach, FLBuilt 2002 · S/N 4496119N4316WHolt Bartlett · Binghamton, NYBuilt 1974 · S/N CE-485N4316ZGardner Richard T · Delta Junction, AKBuilt 1967 · S/N 18-8628N43170Craig John IV · Lilburn, GABuilt 1974 · S/N 32-7400041N43171Flight Leasing Corp · Wilmington, DEBuilt 1983 · S/N 28-8490003N4317BParis Air Inc · Vero Beach, FLBuilt 1983 · S/N 28-8416001N4317DParis Air Inc · Vero Beach, FLBuilt 1983 · S/N 28-8416002N4317GCendejas Agustin · Chino, CAFirst renewal noticeBuilt 1983 · S/N 28-8416003N4317JMiller Anthony J · Rexford, MTBuilt 1967 · S/N 28-22691N4317QPerera Nandana L · Logan, OHBuilt 1971 · S/N 17260217N4317RSam Aviation LLC · Long Beach, CAS/N 17263070N4317TSpanku LLC · Bay Shore, NYBuilt 1983 · S/N 28-8490002N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587N43181New Mexico Flying Eagle Inc DBA · Tucson, AZS/N 28-7415442N43186Aerolina Inc · Hendersonville, NCBuilt 1983 · S/N 28-8416008N43187Frederick Aero Club Inc · Wilmington, DEBuilt 1983 · S/N 28-8490006N4318BFaith Flyers Inc · Wellington, FLBuilt 1983 · S/N 28-8490004N4318RBeaulieu Steven · Georgetown, DEBuilt 1974 · S/N 17263071N4318SFlite Solutions LLC · Beavercreek, OHBuilt 1983 · S/N 28-8411002N4318ZDodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N 28-8416007N4319DPumphrey Anthony D Sr · Little Rock, ARBuilt 1983 · S/N 28-8490007N4319MSale Reported · Aptos, CASale reportedBuilt 1983 · S/N 46-8408005N4319RWoodland William B · Anchorage, AKFirst renewal noticeBuilt 1976 · S/N 18502931N4319SMac Air Inc · Farmington, MOBuilt 1975 · S/N TC-1869N4319XEagle Eye Aerial Imaging LLC · Chagrin Falls, OHBuilt 1975 · S/N 28-7690002N4319YRock Solid Aviation LLC · Lake Charles, LABuilt 1983 · S/N 28-8490010N4319ZNorthland Hangars LLC · Palmer, AKBuilt 1967 · S/N 18-8632N431ARegistered aircraftBuilt 1976 · S/N 17265942N431AFBuha Holdings LLC · Paris, TXBuilt 2003 · S/N 18281193N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221N431CDMother Of Perpetual Succor LLC · Villa Hills, KYBuilt 2005 · S/N 1501N431CELegacy Aviation LLC · Ann Arbor, MIBuilt 1973 · S/N 414-0431N431CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8693N431CRAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11454N431DBDuininck Companies LLC · Prinsburg, MNBuilt 2003 · S/N 29-0288N431DEClark Air Ventures LLC · Awendaw, SCBuilt 2002 · S/N 40.232N431ERegistration Pending · Kokomo, INRegistration pendingBuilt 2007 · S/N 70423N431EAHamilton Dale N · Grand Rapids, MIBuilt 1991 · S/N 05N431FDahlin Joel R · Saint Paul, MNBuilt 1968 · S/N 28-24929N431FPSky West Aviation Inc Trustee · Albuquerque, NMS/N 172S9431N431JDeboer Jon Tanner · Saginaw, TXBuilt 1994 · S/N 431N431JPJoerithan & Mp Aviation LLC · Whittier, CABuilt 2004 · S/N 40.431
Back to AD 2007-04-19 R1