OpenAirDocs.org
AD 86-06-08 R1

Registered aircraft · 491

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:86-06-08-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:86-06-08-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.

N147CGMagic Carpet Ride Aviation LLC · Columbus, OHBuilt 1956 · S/N 1044N147DPWeeks Kermit A · Polk City, FLBuilt 1956 · S/N 1685N147HCDick Richard A · Hutchinson, KSBuilt 1971 · S/N 6790N147RSSugden Richard G · Wilson, WYS/N 2636N147RWNipper Troy R · Texarkana, TXS/N 3097N147SMMazar Stephen M · Flushing, MIBuilt 1956 · S/N 1461N147WBTriple Sss Aviation Inc · Muskegon, MIBuilt 1963 · S/N 2982N147WTAircraft Logistics Services LLC · Rockford, MIBuilt 1964 · S/N 2920N14807Hammock Flying Service Inc · Smithville, ARBuilt 1972 · S/N 25078N14827Wildhorse Helicopters Inc · Pendleton, ORBuilt 1972 · S/N 6837N14861Brown Helicopter Inc · Pensacola, FLBuilt 1972 · S/N 25089N1501LMonahan Robert J · Bulverde, TXBuilt 1971 · S/N 25046N1503LTriple F Flying Inc · Benton, PABuilt 1971 · S/N 25042N15395Magnum Aviation LLC · Goff, KSS/N 2408N153AFarwest Aviation LLC · Billings, MTBuilt 1966 · S/N 3550N153BScotts Helicopter Service · Le Sueur, MNBuilt 1947 · S/N 7N155JNAero-Mobil Inc · Wilmington, DEBuilt 1955 · S/N 1445N157BLewis Gerald K · Bakersfield, CABuilt 1947 · S/N 11N15AROrbic Inc · Camarillo, CABuilt 1963 · S/N 2815N160BJames David R · Wayne, MIBuilt 1947 · S/N 14N16356Modern American Warrior Inc · Spring, TXBuilt 1951 · S/N 536N170HFEfinance LLC · Wichita, KSBuilt 1968 · S/N 3687N170SSOlathe Spray Service Inc · Olathe, COBuilt 1963 · S/N 2827N17611Tc Bouslog LLC · Noblesville, INBuilt 1952 · S/N 1041N1773Aircraft Sales LLC · Caledonia, MIBuilt 1967 · S/N SA51N17SSDodson Larry A · Lone Oak, TXBuilt 1957 · S/N 1982N182BLay Lawrence W · Douglass, KSBuilt 1948 · S/N 36N184BTaz Air Service Inc · Middletown, DEBuilt 1959 · S/N 45N18807Swing Wing Inc · Veedersburg, INBuilt 1975 · S/N YH49N188SHScotts Helicopter Service Inc · Le Sueur, MNS/N 7753N18SSUSA Helicopter Inc · West Winfield, NYBuilt 1966 · S/N 6581N200KVPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1960 · S/N 2258N202CHBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1951 · S/N 301N2098Classic Rotors Museum · Ramona, CABuilt 1963 · S/N 2850N210BL & L Delivery Ltd · Romulus, MIBuilt 1975 · S/N 76N2199Heritage Flight Museum · Burlington, WABuilt 1952 · S/N 604N21MPBack Jeff · Oneonta, NYBuilt 1971 · S/N 7755N2209JWildhorse Helicopter Co Inc · Pendleton, ORS/N 6710N2211NRoberts Edgar S · Washoe Valley, NVS/N 2950N222AJWatson Tommy R · Thibodaux, LABuilt 1973 · S/N 25122N22353Rye Corp LLC · Lenoir City, TNBuilt 1970 · S/N 7721N2240WYarak Aviation LLC · Big Timber, MTBuilt 1962 · S/N 6752N2248WWilbur-Ellis Co · Salinas, CABuilt 1969 · S/N 7961N2249WWilbur-Ellis Co · Salinas, CABuilt 1969 · S/N 7963N2251WJohnson Aerial Spraying LLC · Brayton, IAS/N 7965N225BHammock Flying Service Inc · Smithville, ARBuilt 1949 · S/N 149N2266ADt Pralle Enterprise Inc · Hampton, IABuilt 1966 · S/N 3557N2277WSterling Lane Helicopters LLC · Farmingdale, NYBuilt 1971 · S/N 6829N2292BMy Way LLC · Missoula, MTBuilt 1957 · S/N 1972N22APGospel Ministries International Inc · Collegedale, TNS/N 1144
Back to AD 86-06-08 R1