AD 84-10-01 R1

Registered aircraft · 20,481

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.

N9538ENorthwoods Air LLC · Orono, MEBuilt 1984 · S/N 18268422N9538XTodd Robert L · Alvarado, TXBuilt 1961 · S/N 21057838N9539DBohemia Aviation LLC · Niagara, WIS/N 18280184N9539HNorthwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 18267961N9539LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1998 · S/N 18280185N9539PNichols Aviation LLC · Middletown, DEBuilt 1998 · S/N 18280186N9539RAdams Scott A · Glenview, ILS/N 18280172N953CCScruggs Ken · Plain City, OHBuilt 1975 · S/N 18264109N953RRGig Aviation LLC · Harrisburg, ARBuilt 2007 · S/N 18282009N953STBoone Keith · Cabot, ARBuilt 1976 · S/N 21061155N9540TChino Aviation Inc · Chino, CABuilt 1960 · S/N 57340N9540XWhitetop Air LLC · Wilmington, DEBuilt 1985 · S/N 18268550N9541BBodick John K · Anchorage, AKBuilt 1957 · S/N 32838N9541TNevill John D · Tahoka, TXS/N 57341N9542TLarsen Richard A · Wannaska, MNBuilt 1960 · S/N 57342N9542WState Of North Carolina · Raleigh, NCBuilt 1998 · S/N 18280136N9543FEvans Michael · Punta Gorda, FLBuilt 1998 · S/N 18280219N9543GHi Low Aviation LLC · Alpine, TXBuilt 1998 · S/N 18280245N9543XBarth Samuel · Fonda, NYS/N 21057843N9544QPhoto Services Unlimited · Augusta, MEBuilt 1998 · S/N 18280291N9544SJourney Holdings LLC · Reform, ALBuilt 1998 · S/N 18280149N9544XB&B Aviation LLC · Arlington, WABuilt 1961 · S/N 21057844N9545XRichardson Dana C · Okeechobee, FLBuilt 1961 · S/N 21057845N9546GSale Reported · Emerson, IASale reported, canceledBuilt 1974 · S/N 18263402N9546TAerographics Inc · St Cloud, MNBuilt 1960 · S/N 57346N9546XN9546x LLC · Lakeville, MNBuilt 1986 · S/N 18268551N9547XCundiff Zackery A · Klamath Falls, ORBuilt 1962 · S/N 21057847N9548XMclenaghan Alvin · Phoenix, AZBuilt 1962 · S/N 21057848N95494Valiair Limited Co Trustee · Casper, WYS/N 18266558N9549GMacica Stephen J DBA · Truckee, CABuilt 1972 · S/N U20601749N954CCSavvas Evangelos · Edina, MNBuilt 1976 · S/N 18265290N954PWWeckbacher Paul J Jr · Inverness, FLBuilt 1981 · S/N U20606288N95500Pond Scott L · Moorpark, CABuilt 1978 · S/N 18266560N9551WBcbc Aero Services LLC · Dover, DEBuilt 1998 · S/N 18280207N95521Martin Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18266566N95528Welch Clare A · Longboat Key, FLBuilt 1978 · S/N 18266567N9552RCauv LLC · Cincinnati, OHBuilt 1998 · S/N 18280167N9553SHunters Adventures LLC · Kennesaw, GABuilt 1998 · S/N 18280254N9553XMccarthy Sean P · Jacksonville Beach, FLBuilt 1962 · S/N 21057853N95540Gracejet Aviation LLC · Brownsboro, TXS/N 18266571N95541Pershing Air LLC · Sheridan, WYBuilt 1978 · S/N 18266572N95544Keller Lucas J · Vale, ORBuilt 1978 · S/N 18266574N9554GMorse Donald · Priest Lake, IDBuilt 1972 · S/N U20601754N9555XWalker Scott · Mammoth Lakes, CABuilt 1974 · S/N 18263495N9556ZIsland Aircraft LLC · Anchorage, AKBuilt 1918 · S/N U20606543N9557PHendrix Steven · Bakersfield, CAS/N 18280294N9557XCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 18268553N9558BGrap Jeffrey G · Statham, GABuilt 1957 · S/N 32855N9558TWatson Stephen C · Flemingsburg, KYBuilt 1960 · S/N 57358N9558XWagner Larry D · Raleigh, NCBuilt 1986 · S/N 18268554
Back to AD 84-10-01 R1