OpenAirDocs.org
AD 83-07-22 R1

Registered aircraft · 35

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:83-07-22-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:83-07-22-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.

N14XTMccole Kevin · Brookline, NHBuilt 1986 · S/N 361N170WLIdpa Aircraft Leasing LLC · Austin, TXBuilt 2012 · S/N 468/CN291CJArndt Scott · Pearland, TXBuilt 1983 · S/N 291N300LFAspen Helicopters Inc · Oxnard, CAS/N 295N321RTBarr Air Patrol LLC · Mesquite, TXBuilt 1979 · S/N 189N357PNWashington State Dept Of Fish And Wildlife · Olympia, WABuilt 1985 · S/N 357-38/TCN3927UFresh Air Aviation Inc · Charlevoix, MIBuilt 1983 · S/N 282N420KWCleghorn Aviation Inc · Key West, FLBuilt 1983 · S/N 294N4465YIdpa Aircraft Leasing LLC · Austin, TXBuilt 1983 · S/N 320-26/TCN468CBorn John · Jupiter, FLBuilt 1980 · S/N 213N480NROhio Division Of Wildlife · Columbus, OHBuilt 1986 · S/N 345N483FWNeel Aviation LLC · Lakeland, FLBuilt 1983 · S/N 271N490NROhio Department Of Natural Resources · Columbus, OHBuilt 1982 · S/N 281N4958KPilot Corp Of The Palm Beaches DBA · West Palm Beach, FLBuilt 1983 · S/N 269N53695N53695 LLC · Miami, FLBuilt 1979 · S/N 126N564BCBravo Charlie Aviation Inc · Middletown, DENon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 299N590WASchellhorn Frederick Jr · Harxheim MainzS/N 61N6307MN6307m LLC · Terra Ceia, FLBuilt 1985 · S/N 306N668TCOly Aero LLC · Central Point, ORS/N 317-25/TCN683KWOwyhee Air Research LLC · New Braunfels, TXBuilt 1983 · S/N 305N684KWFour Kilo Whiskey LLC · Key West, FLBuilt 1991 · S/N 387N686KWSix Kilo Whiskey LLC · Key West, FLS/N 364N68VAAspen Helicopters Inc · Oxnard, CABuilt 2007 · S/N 440/CN68VRGene Coleman Machine Inc · Menominee, MIBuilt 2004 · S/N 434N69HANorth County Flying LLC · North Palm Beach, FLBuilt 1990 · S/N 373N73N73n Aviation LLC · North Miami Beach, FLS/N 230N742WGTop View Corp · Livingston, MTBuilt 2023 · S/N 522/CN75NLFresh Air Aviation Inc · Charlevoix, MIS/N 312N7668BPacific Flight Academy LLC · Honolulu, HIS/N 28N766FEdge Logistics Inc · South Lake, TXBuilt 1983 · S/N 313-23/TCN789FWWalton Marketing Inc · Fort Worth, TXS/N 28820TCN881BABarr Air Patrol LLC · Mesquite, TXBuilt 1983 · S/N 274N88NAspen Helicopters Inc · Oxnard, CAS/N 352-37/TCN90UBS-T Manufacturing Inc · Granbury, TXBuilt 1984 · S/N 302N920AAGoins Clay Jefferson · West Park, FLBuilt 1978 · S/N 198
Back to AD 83-07-22 R1