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.

N35BZKapusniak Slawomir · Easton, PABuilt 2004 · S/N 905-320-746N35CFGilbert David · Othello, WABuilt 1972 · S/N 18261235N35CGComesa Service Group · Middletown, DEFirst renewal noticeBuilt 1972 · S/N D-9373N35CKColeman Tyler R · Sierra Vista, AZBuilt 1993 · S/N 20165N35CLScherer Zebulon R · Anchorage, AKBuilt 1989 · S/N 353N35CPRayl Curtiss C · Pensacola, FLBuilt 1979 · S/N 79-30954N35CWTimoney James M · Auburn, MEBuilt 1979 · S/N 32-7940170N35DQPalone Vincent E · Waynesburg, PABuilt 1984 · S/N 383N35DTTeufel Armin U · Phelan, CAFirst renewal noticeBuilt 1998 · S/N 321N35ECKoda Bear Properties LLC · Wilmington, DEBuilt 2004 · S/N 0883N35EKHaupt Erik · Great Barrington, MABuilt 1979 · S/N D-10238N35ESMurphy Joel · Flowermound, TXBuilt 1965 · S/N D-7918N35FCook Stephen D · Osceola, INBuilt 1960 · S/N CD-72N35FASt Louis Soaring Association · Saint Louis, MOBuilt 1964 · S/N 253291N35FBEwins John H · Danville, CABuilt 1969 · S/N JMKB-1N35FCTransonic Inc · Auburn, CAS/N 29-0369N35FLWhitcomb Keith · Villa Rica, GABuilt 2019 · S/N 73167N35GMSt Cloud Flying Club LLC · Saint Cloud, MNBuilt 2003 · S/N 0478N35GPLimon Hector Jr · Lubbock, TXBuilt 1956 · S/N D-4901N35GVMartin Scott W · Bowie, MDBuilt 1976 · S/N 18264828N35HBDownes Greg · Iowa City, IABuilt 1988 · S/N CP-59N35HPQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N 3005N35HRTrantina Robert J · Desert Aire, WAS/N ROSS 0011N35HUFilimoehala Nicholas C · Kaysville, UTBuilt 2013 · S/N 3195N35HVProdigy Aviation LLC · Port Orange, FLBuilt 1957 · S/N D-5236N35JSkybound Shenanigans LLC · Dubuque, IABuilt 1958 · S/N D-5699N35JCRogowski Paul · Dallas, GABuilt 1964 · S/N TC-828N35JFBerry Damon R · Granbury, TXBuilt 2012 · S/N 1689N35JGJalu Financial Corp · Gray, GABuilt 1963 · S/N D-7181N35JTBeech 36 LLC · Siloam Springs, ARBuilt 1969 · S/N E-162N35JWN35jw LLC · Enid, OKBuilt 1959 · S/N D-5872N35KKearns Jeff C · Carrier Mills, ILBuilt 1995 · S/N 20482N35KAHacker Timothy J · Pangburn, ARBuilt 1979 · S/N D-10231N35KCBuchanan Tevah · St George, UTBuilt 1996 · S/N 3-608N35KJBunn John Timothy · Winter Garden, FLBuilt 1972 · S/N D-9326N35KWCoy Walter Thomas · Titusville, FLBuilt 1975 · S/N D-9827N35LABohachevsky John V · Bloomfield, KYBuilt 1966 · S/N 670184N35LBWebb John M · Chugiak, AKBuilt 1973 · S/N 1N35LCClaussen Larry Scott · Independence, ORBuilt 2018 · S/N 91627N35LFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N D9820N35LGAnderson Charles · Bakersfield, CABuilt 1958 · S/N D-5529N35LVDelta Fox Aviation LLC · Fort Worth, TXBuilt 1969 · S/N D-8900N35MSimmons Dennis L · Wichita, KSBuilt 1970 · S/N D-9143N35MASidetrack Investments LLC · Flower Mound, TXBuilt 1969 · S/N D-8925N35MBBarker Max · Caldwell, IDBuilt 2000 · S/N 80725N35MDGarbalosa Ryan · Myrtle Beach, SCBuilt 1995 · S/N 29-0047N35MLNelson Aircraft Sales Inc · Minot, NDBuilt 1974 · S/N 428-74N35MQFly Planet LLC · Kalispell, MTBuilt 1973 · S/N 18262505N35MTToft Michael O · Brock, TXBuilt 1966 · S/N D-8338N35MVWeaver Kibwe · Kalamazoo, MIBuilt 1967 · S/N D-8617
Back to AD 2007-04-19 R1