OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N9842WIreys Charles G · Tok, AKBuilt 1967 · S/N 28-23350N9843WBeeson Jeffrey K · Crowley, TXBuilt 1967 · S/N 28-23351N9844WBarson Nicholas J · Fort Pierce, FLBuilt 1967 · S/N 28-23355N9845WLipskoch Anthony P · Buhl, IDS/N 28-23356N9846WVladimir Martyanov · Chandler, AZBuilt 1967 · S/N 28-23357N9847WLukas Craig S · Omaha, NEBuilt 1967 · S/N 28-23359N9849WKauenhofen Jacobo DBA · Boley, OKBuilt 1967 · S/N 28-23361N984SWWaits Paul C · Blanchard, OKBuilt 1969 · S/N 28-5415N9850WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23362N9853WReynolds Stuart N II · Sutherland, VABuilt 1967 · S/N 28-23366N9854WPerry Michael · Wilmer, ALBuilt 1967 · S/N 28-23367N9855WWilliamson Flying Club Inc · Williamson, NYBuilt 1967 · S/N 28-23369N9858WPearce Ronald M · Madison Heights, MIBuilt 1967 · S/N 28-23372N9859WBerry Meredith W III · Covington, LABuilt 1967 · S/N 28-23374N9860WCalkins Ray · Socorro, NMS/N 28-23375N9862WWagler Randal Clarence · Bradenton, FLS/N 28-23377N9863WRohde Bruce G · Fife, WABuilt 1967 · S/N 28-23379N9864WDuell David J · Sparks, NVS/N 28-23380N9867WBeuscher Sharon A · Fairborn, OHBuilt 1967 · S/N 28-23385N9868WCarpenter Robert A · Westfield, NYBuilt 1967 · S/N 28-23386N9869WJohnson Charles C · Fitzgerald, GABuilt 1967 · S/N 28-23387N9870WTaffin Air LLC · Mount Vernon, OHBuilt 1967 · S/N 28-23389N9871WLemerande Alan Robert Jr · Jefferson City, MOBuilt 1967 · S/N 28-23390N9874WMcanally Cameron F · Battle Ground, WABuilt 1967 · S/N 28-23394N9876WFoster John D · Grapevine, TXBuilt 1967 · S/N 28-23396N9878WBenton Michael L · Gilbert, SCBuilt 1967 · S/N 28-23398N9880WJuhl Aaron · Overland Park, KSBuilt 1967 · S/N 28-23400N9886WLathem Emma K · Amarillo, TXS/N 28-23406N9888WSchlafer Antone · Lincoln, CABuilt 1967 · S/N 28-23408N9889WFaix James M · Sarasota, FLBuilt 1967 · S/N 28-23409N9890WKoryciak Robert L · Boling, TXBuilt 1967 · S/N 28-23410N9893WSky High Aviation LLC · Streamwood, ILBuilt 1967 · S/N 28-23413N9896WKnapp Joseph E Jr · Clermont, FLBuilt 1967 · S/N 28-23416N989TMPrestige Wordwide Km LLC · Lynn Haven, FLS/N 28-24164N98WWSmith Kent L · Doniphan, MOBuilt 1972 · S/N 28-7305179N9900WGinther Wallace S · Quincy, ILBuilt 1967 · S/N 28-23420N9901WWilliams Air Power Inc · Lowell, MIS/N 28-23421N9902WDavis Robert D · Murfreesboro, TNBuilt 1967 · S/N 28-23422N9904WTraweek Parrish C · San Manuel, AZBuilt 1967 · S/N 28-23424N9906WBelmont Thomas M · Boca Raton, FLBuilt 1967 · S/N 28-23426N9909WVafaie Frederick · Williston, FLBuilt 1967 · S/N 28-23429N990PHSanchez Leonides R · Alton, ILBuilt 1965 · S/N 28-2797N990VTWang Jinrao · Peachtree City, GABuilt 1969 · S/N 28-25910N990XDl Industries Inc · Claremont, NHBuilt 1968 · S/N 28-5251N9911WCategory One Aviation LLC · Atascadero, CABuilt 1967 · S/N 28-23433N9913WJcl Equipment Rental · Coleta, ILBuilt 1967 · S/N 28-23434N9914SSheffield Robert A · Mooresville, NCBuilt 1967 · S/N 28-23672N9914WYellow Bird Flying Club · Toledo, OHBuilt 1967 · S/N 28-23435N9915WAlimardani Shahrakh · Aguanga, CABuilt 1967 · S/N 28-23436N9916WCulp Mason J · Bonney Lake, WABuilt 1967 · S/N 28-23438
Back to AD 96-10-01 R1