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.

N7254JMinkel Chad A · Chanhassen, MNBuilt 1968 · S/N 28-24597N7254WMonroe County Flyers And Sales LLC · Sweetwater, TNS/N 28-1083N7255FN7255f LLC · Cedar City, UTBuilt 1968 · S/N 28-25173N7255JRury Bryan · Midlothian, TXBuilt 1968 · S/N 28-24598N7256FZihala William · North Little Rock, ARBuilt 1968 · S/N 28-25174N7257FHedberg Jacob R · Jordan, MNS/N 28-25175N7257JHardin John M · Terrell, TXBuilt 1968 · S/N 28-24601N7258FCochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 28-25177N7260FRandy'S Rodz LLC · Missoula, MTBuilt 1968 · S/N 28-25178N7260WO'Day John E · Rindge, NHBuilt 1963 · S/N 28-1092N7261WKurywchak Daniel A · Cameron Park, CABuilt 1963 · S/N 28-1093N7262FParlee Chad E · Lakeport, CABuilt 1968 · S/N 28-25181N7262JKemp Lyman E · Ketchikan, AKBuilt 1968 · S/N 28-24584N7262WDube Colin T · Minot, MEBuilt 1963 · S/N 28-1095N7263JKl Aviation LLC · Catawba, NCBuilt 1968 · S/N 28-24548N7263WKontour Shawn K · Wheatland, WYBuilt 1963 · S/N 28-1096N7264FPodyaire LLC · Ruston, LAS/N 28-25184N7264JHoseney Richard W Jr · Como, MSBuilt 1968 · S/N 28-24532N7264WFehringer John T · Sidney, NES/N 28-1097N7265FShouling & Philip Enterprise · Lancaster, CAS/N 28-25185N7265JSwoboda Charles · Anchorage, AKBuilt 1968 · S/N 28-24528N7265WSayles Michael A · Shorewood, ILBuilt 1963 · S/N 28-1098N7266JPaolo Keath R · Carlton, ORBuilt 1968 · S/N 28-24520N7266WNewland Hunter R · West Valley City, UTBuilt 1963 · S/N 28-1099N7267FRegistered aircraftBuilt 1968 · S/N 28-25187N7267JSe Aviation LLC · Boise, IDBuilt 1968 · S/N 28-24464N7267WGillespie Michael Lee · Jacksonville, FLBuilt 1963 · S/N 28-1185N7269FChandler Joseph · Amana, IABuilt 1968 · S/N 28-25191N7269WButtercup Express LLC · Woodward, OKS/N 28-1103N7270JJones Frederick W · Burgaw, NCS/N 28-24610N7270WEast West Aviation Club · DuffelS/N 28-1105N7274JFairway Chalet LLC · San Antonio, TXS/N 28-24617N7274WSky & Sea Horizons LLC · Memphis, TNBuilt 1965 · S/N 28-2895N7275JAmon Mccrary Bryley · Bullard, TXBuilt 1968 · S/N 28-24618N7275LLaughlin Jonathan · Rich Hill, MOBuilt 1965 · S/N 28 2405N7275WHinkley Dean E · Sun City, FLBuilt 1963 · S/N 28-1111N7276JWheeler Kelly E · Columbia Falls, MTBuilt 1968 · S/N 28-24619N7276WFlyright Aviation LLC · Plymouth, MNBuilt 1963 · S/N 28-1114N7277WOrganic Media Studio LLC · Hattiesburg, MSBuilt 1963 · S/N 28-1146N727AJMeyer Joshua · Fairborn, OHBuilt 1968 · S/N 28-24624N727FLOgilvie Danny L · Yucca Valley, CABuilt 1972 · S/N 28-7225431N7280CGriff Air LLC · Aurora, ORBuilt 1975 · S/N 28-7625074N7280FHarmon Sharon O · Pasco, WAFirst renewal noticeBuilt 1968 · S/N 28-25192N7281JBilbrey Don R · Georgetown, OHBuilt 1968 · S/N 28-24626N7282JWirth Alan Patrick · Callaway, MDBuilt 1968 · S/N 28-24629N7282WHoracio Marcelo Knop · Hialeah, FLS/N 28-1122N7284JGiermek Peter T · Olean, NYBuilt 1968 · S/N 28-24631N7285FKulp Clayton H · Wichita, KSS/N 28-25198N7286WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1126N7287JJames Leroy R · Renfrew, PABuilt 1968 · S/N 28-24638
Back to AD 96-10-01 R1