AD 84-10-01 R1

Registered aircraft · 20,483

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:84-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:84-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.

N3479SCook Mark C · Hutto, TXBuilt 1964 · S/N 18255879N3480FAltus Aircraft LLC · Taylor, TXFirst renewal noticeBuilt 1966 · S/N 18257480N3480USoule Clauson D · Cooperstown, NYS/N 18254880N3481FWells Garry L · Scotia, NEBuilt 1966 · S/N 18257481N3481SDorman Richard E · Mesa, WABuilt 1964 · S/N 18255881N3481USmith Lowell A · Gresham, ORBuilt 1963 · S/N 18254881N3482UMitchell Philip T · Moreland, GABuilt 1963 · S/N 18254882N3482VBorden Leon D · Arcadia, CAS/N 7182N3483RCentury White Worldwide Inc · Casper, WYBuilt 1968 · S/N 18258783N3483SHickey Bill J · La Veta, COBuilt 1964 · S/N 18255883N3483UPool Robert Brooks · Lake Charles, LABuilt 1963 · S/N 18254883N3483YGrimes William H · Seabrook, SCBuilt 1968 · S/N 18051983N3484RTouch And Go Aviation LLC · Jackson, MNBuilt 1968 · S/N 18258784N3484VWeiss Elliott · Fresno, TXS/N 7184N3484YSport Obermeyer Ltd · Aspen, COBuilt 1968 · S/N 18051984N3485LEhalt Christopher J · Lester Prairie, MNBuilt 1967 · S/N U206-0785N3485SThorp Contractors LLC · Vinita, OKBuilt 1964 · S/N 18255885N3485VMyron Alexander Tedrow · Morristown, TNBuilt 1948 · S/N 7211N3486UZhills Pilot LLC · Zephyrhills, FLBuilt 1963 · S/N 18254886N3487SAscent Investments LLC · Kasota, MNS/N 18255887N3487ULawser Ron · Townsend, MTBuilt 1963 · S/N 18254887N3488SBarbosa Javier · Edinburg, TXBuilt 1964 · S/N 18255888N3488VCurrier Susan · Greenvlle Jct, MEBuilt 1948 · S/N 7192N3489RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18258789N348ABBledsoe Alvin · Horseshoe Bay, TXBuilt 1979 · S/N 18266934N348TCWilliams Ryan D · Panama City, FLBuilt 2004 · S/N 18281434N3490FRegistered aircraftBuilt 1966 · S/N 18257490N3490GTucker Shad E · Sandia, TXS/N 51790N3490RFreiberger Gary D · Fort Lauderdale, FLBuilt 1968 · S/N 18258790N3490YRouse & Rouse-Houck LLC · Gunnison, COBuilt 1968 · S/N 18051990N3491SApollo Aviation Inc · Mound, MNFirst renewal noticeBuilt 1964 · S/N 18255891N3491UMalchoff Kevin R · Lake View, NYBuilt 1963 · S/N 18254891N3491VKalbermatter Guillermo A · Ventura, CABuilt 1948 · S/N 7195N3492UMaligator Air LLC · Missoula, MTBuilt 1963 · S/N 18254892N3493SCola William Patrick · Colfax, CABuilt 1964 · S/N 18255893N3493VWhalen John M III · Boise, IDS/N 7197N3494FParadise Aviation LLC · Shoreline, WABuilt 1966 · S/N 18257494N3494SLadder Livestock Company LLC · Savery, WYS/N 18255894N3494YAltitude Fix Aviation LLC · Mesa, AZS/N 18051994N3495LSaqul'Aq Air LLC · Coupeville, WABuilt 1967 · S/N U206-0795N3495RC182 Flyers LLC · Las Cruces, NMS/N 18258795N3495S3495s LLC · Prescott, AZBuilt 1964 · S/N 18255895N3496YPincus Howard E · Grass Valley, CABuilt 1968 · S/N 18051996N3497RWhitfield Derwin C · Picayune, MSBuilt 1968 · S/N 18258797N3497SHenry Bruce N · Bloomfield, NMBuilt 1964 · S/N 18255897N3497YBraden John C · Anchorage, AKBuilt 1968 · S/N 18051997N3498FHole In The Sky Aviation LLC · Dallas, TXBuilt 1966 · S/N 18257498N3498SEnz Vineyards Inc · Hollister, CABuilt 1964 · S/N 18255898N3498UVintage Flyers LLC · Easton, PABuilt 1963 · S/N 18254898N3499SSky'S Mooney LLC · Missoula, MTBuilt 1964 · S/N 18255899
Back to AD 84-10-01 R1