OpenAirDocs.org
AD 83-03-02 R1

Registered aircraft · 1,083

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-03-02-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-03-02-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.

N67FABas Part Sales LLC · Greeley, COBuilt 1994 · S/N 5168N67HFPadgett Ag Rotors LLC · Missoula, MTBuilt 1978 · S/N 1280403DN67LHTurn 7 Leasing LLC · Helena, MTBuilt 1973 · S/N 630484N685KWFive Kilo Whiskey LLC · Key West, FLBuilt 1983 · S/N 2120N686AMAir Methods LLC · Greenwood Village, COBuilt 1997 · S/N 53160N68PHMercury Aviation Inc · Flowood, MSBuilt 1988 · S/N 3988N690PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0613EN690WAWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 1170237DN691PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0611EN692PDBoard Of Police Commissioners · Kansas City, MOBuilt 2012 · S/N 0612EN694ATSzucs Attlia · Port Orange, FLBuilt 1988 · S/N 0310EN695MCTom Cline Helicopter LLC · Lake Ozark, MOBuilt 1968 · S/N 300N69875Gateway Youth Aeronautical Foundation · Maryland Heights, MOBuilt 2001 · S/N 5282N69DVTripwire South LLC · Gettysburg, PABuilt 1981 · S/N 410950DN69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025N69GECbft LLC · Mobile, ALBuilt 1990 · S/N 0394EN69TPAirtime Marketing LLC · Middletown, DEBuilt 1994 · S/N LN063N6BUAgricultural Air Services LLC · Jupiter, FLBuilt 1988 · S/N 4034N6MQR Consulting & Sales Inc · Carson City, NVS/N 7321N6QDSierra Golf Rotorcraft LLC · Wilmington, DEBuilt 1992 · S/N 4247N6ULHelicopters Inc · Wilmington, DEBuilt 1993 · S/N 52015N6YJetran LLC · Horseshoe Bay, TXBuilt 1989 · S/N 001N700FKBhh Leasing #4 LLC · Pensacola, FLBuilt 1989 · S/N 2201N701HAHelo N701ha LLC · Richmond, VABuilt 2001 · S/N 4554N701KPKp Properties LLC · Auburn, WAS/N 1280417DN702BABlue Air Training Corp · Las Vegas, NVBuilt 1986 · S/N 018N702CG702cg LLC · Muskogee, OKBuilt 1960 · S/N 6030N702SH702sh LLC · Kalispell, MTBuilt 1978 · S/N 1280404DN70512Bank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N LN092N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836N705KPOceans Alaska LLC · Dover, DEBuilt 1996 · S/N 0530EN705MPSmith Mark K DBA · Hubertus, WIBuilt 1990 · S/N 0405EN7062XPatriot Aviation Inc · Greenville, DES/N S-793N7079KDah Aircraft LLC · Georgetown, SCBuilt 1981 · S/N 610988DN707HJIndustrial Helicopters LLC · Lafayette, LABuilt 1980 · S/N 3173N707MDEfw Inc · Fort Worth, TXBuilt 1984 · S/N 5306N707SJCtrg Aviation Holdings LLC · Lakeway, TXBuilt 1981 · S/N 3561N709ACJbd Enterprises Inc · Englewood, COBuilt 1982 · S/N 5114N710ACJbd Enterprises Inc · Englewood, COBuilt 1982 · S/N 5234N711HLMann Laurence F · San Jose, CABuilt 1987 · S/N 7398N711KVAa Leasing Lp · Kilauea, HIBuilt 1977 · S/N 1070212DN711ZWMalmrose Heli Services Inc · North Salt Lake, UTBuilt 1979 · S/N 2691N712CACatalyst Aviation LLC · Hammonton, NJBuilt 1987 · S/N 5362N713BCTimcoaviation LLC · Purvis, MSBuilt 1982 · S/N 3671N716CBCbhelos LLC · Chesapeake, VABuilt 1980 · S/N 500701DN716KVAa Leasing Lp · Lihue, HIBuilt 1990 · S/N 0407EN716VLAirwayplanner.Com LLC · Sands Point, NYBuilt 1992 · S/N 4203N7173FFour Creeks Aviation Inc · Visalia, CAS/N 2011N7173SCraig Helicopters Inc · Craig, COBuilt 1965 · S/N 2351N719CBCbhelos LLC · Chesapeake, VABuilt 1972 · S/N 890
Back to AD 83-03-02 R1