OpenAirDocs.org
AD 78-11-02 R1

Registered aircraft · 1,179

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:78-11-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:78-11-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.

N713BCTimcoaviation LLC · Purvis, MSBuilt 1982 · S/N 3671N7159HPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51397N7161JGlobal Overhaul Inc · Lafayette, LAS/N 135N716VLAirwayplanner.Com LLC · Sands Point, NYBuilt 1992 · S/N 4203N71JJInterstate Helicopters Inc · Bethany, OKBuilt 1989 · S/N 51329N71WPSimjet Center Inc · Granbury, TXS/N 2702N720BGentem Inc Trustee · Wilmington, DEBuilt 1980 · S/N 45452N72365Glacier Aviation Inc · Olympia, WABuilt 1972 · S/N 44061N7242USl Jet H LLC · Franklin, NCBuilt 1972 · S/N 44038N7250EAg Air Inc · Oakdale, CABuilt 1974 · S/N 1529N726HGm Leasing Company LLC · Broussard, LABuilt 1992 · S/N 51548N727BBDle Corp · Lewes, DES/N 735N73AJGreenway Avia Inc · Wilmington, DES/N 922N73AMMetroplex Flight Services LLC · Fort Worth, TXS/N 3473N744TVU S Helicopters Inc · Marshville, NCBuilt 1985 · S/N 3863N74678Southmark Aviation Inc · Hattiesburg, MSBuilt 2001 · S/N 5274N747DMHunter Construction Group Inc · Mooresville, NCBuilt 1981 · S/N 3510N749FFHunt-Lo Farms LLC · Chesterland, OHBuilt 1983 · S/N 45773N74AJAerial Control Inc · Brentwood, CABuilt 1979 · S/N 2751N7508PReece Michael · Marathon, FLBuilt 2006 · S/N 4611N75454Realstaff Rocket LLC · Salem, ORS/N 5280N758ERPer-Dar Helicopter LLC · Houston, TXBuilt 1976 · S/N 2058N75CWChem Air LLC · Shreveport, LABuilt 1975 · S/N 1762N75YLinville Manor LLC · Reidsville, NCBuilt 1994 · S/N 4304N762LCLeon County Sheriffs Office · Tallahassee, FLBuilt 1995 · S/N 4363N764CLKestrel Enterprises Inc · Sun City, AZFirst renewal noticeS/N 2811N7650MAnw Investment Group LLC · Denham Springs, LABuilt 1971 · S/N 624N76544Churchill Scott · Jordan, MNBuilt 2001 · S/N 5273N76DCAdvanced Trucking LLC · Kalispell, MTBuilt 1980 · S/N 45471N76MQRidge Helicopter LLC · Wilmington, DEBuilt 1980 · S/N 3111N76PECarson Secure Transport East LLC · Carson City, NVBuilt 1975 · S/N 1818N76TLJ L Smith Enterprises LLC · Jackson, KYBuilt 1999 · S/N 4523N770HPDodson International Parts Inc · Rantoul, KSBuilt 2007 · S/N 4624N77766Usda Aphis Wildlife Services · Cedar City, UTBuilt 2001 · S/N 5279N777CPWild Goose Airways Of Plant City LLC · Thonotosassa, FLS/N 3429N777EMAlaskan Wings LLC · Anchorage, AKBuilt 1983 · S/N 45767N784FNascar Aviation LLC · Silverado, CABuilt 1978 · S/N 2508N785CBHarr Jeremy E · Kingsport, TNBuilt 1989 · S/N 4051N78906King County Sheriffs Office · Seattle, WABuilt 2001 · S/N 5277N789SJAgricultural Air Services LLC · Jupiter, FLS/N 2078N78AMBell206 LLC · Anchorage, AKBuilt 1989 · S/N 4060N78BRMontana Air Tankers LLC · Three Forks, MTBuilt 1988 · S/N 4001N78MEElliott Enterprises Group LLC · Wilmington, DEBuilt 1981 · S/N 3442N78NLH&G Farms Inc · Corcoran, CABuilt 1974 · S/N 1561N790RBRight Brother Aviation LLC · Rome, NYBuilt 1988 · S/N 51248N7935JAerospace Trust Management LLC Trustee · Wilmington, DES/N 652N7963JSan Juan Aviation LLC · Wilmington, DEBuilt 1971 · S/N 685N7978KMowata Farms LLC · Mamou, LABuilt 1982 · S/N 45492N79987Usda Aphis Ws · Cedar City, UTBuilt 2001 · S/N 5278N79AEAvid Aviation Group Inc · Jupiter, FLBuilt 1980 · S/N 45436
Back to AD 78-11-02 R1