OpenAirDocs.org
AD 75-27-09 R2

Registered aircraft · 275

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:75-27-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-27-09-R2')
  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.

N7826LTri-State Warbird Museum · Batavia, OHBuilt 1951 · S/N AF-86N7916ABeechcraft Heritage Museum Inc · Tullahoma, TNS/N AF-824N7998KHoughton Justin K · North Ferrisburg, VTBuilt 1965 · S/N BA-699N79AGAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1952 · S/N A-806N79MBSomers Charles M · Hillsboro, ORBuilt 1942 · S/N 4185N7BSRunyon Aviation LLC · Fort Worth, TXBuilt 1954 · S/N BA-18N7MBGlenn Michael H · Midland, TXBuilt 1959 · S/N BA-448N80036Beechcraft Heritage Museum · Tullahoma, TNBuilt 1946 · S/N A-187N80152Culpepper Matt D · Las Vegas, NVBuilt 1946 · S/N A-112N80197Pgt Nuclear LLC · College Station, TXS/N A-171N80240Beech 18 Holdings LLC · Sheridan, WYBuilt 1951 · S/N AF-75N80323Bachus & Son Inc · Wichita, KSBuilt 1957 · S/N AF-1N80373Virgil J Tatman · Casper, WYS/N A-273N80388Valiair Lc Trustee · Casper, WYBuilt 1946 · S/N A-288N81GBCarolina Aero Tech LLC · Hilton Head Island, SCBuilt 1944 · S/N 7881N8389HPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1958 · S/N 51-11836AN843TBFarwell Jesse R · Albion, NYS/N A217N8476HMccole Joanne · Brookline, NHS/N BA-749N8495AQualitair LLC Trustee · MichelstadtS/N BA-668N8504Clay-Klein LLC · Indianapolis, INBuilt 1952 · S/N AF-682N8627AMckinney Steve R · Hamersville, OHBuilt 1957 · S/N BA-283N8640EGrimes Flying Lab Foundation · Urbana, OHS/N AF-510N868LSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N A-173N8720RMorrison Neil E · Port Townsend, WABuilt 1958 · S/N 52-10681N87690Montana Sitework LLC · Rainbow City, ALS/N AF-528N87692Hill Vincent T · Bucyrus, KSBuilt 1952 · S/N AF-619N876NSteeves Brian G · Wahpeton, NDS/N 52-10876NN87711Planeview Aviation Services Inc · Ahoskie, NCS/N BA-650N87AZBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1936 · S/N 178N8934MLance Toland Ltd · Griffin, GABuilt 1964 · S/N BA-664N897SBCascade Airways LLC · Jefferson, ORBuilt 1958 · S/N BA-385N9030BShe Said Yes LLC · Verona, ILBuilt 1962 · S/N BA-641N90460Mitchell Aircraft Components Inc · Borrego Springs, CABuilt 1958 · S/N A-937N90502Glover William Scott · Mt Pleasant, TXBuilt 1947 · S/N A-346N90552Aeropacific Corp · Idaho Falls, IDBuilt 1948 · S/N A-420N90628Deductionpros LLC · Longview, TXS/N A-809N908Heinze Gregory L · Little Rock, ARBuilt 1945 · S/N A-36N909GPRegistered aircraftBuilt 1957 · S/N BA-236N90TTTwin Beech Partners LLC · Virginia Beach, VABuilt 1957 · S/N BA-335N9109RBobby Younkin Airshows & Sales Inc · Siloam Springs, ARS/N 4383N912KKEllis Ronald G · N Fort Myers, FLS/N AF-426N9157ZDakota Express LLC · Wilmington, DES/N AF-884N9172ZNighthawk Air Systems Inc · Palmetto Bay, FLS/N AF-604N924JRegistered aircraftS/N BA-163N92756Dakota Express LLC · Wilmington, DEBuilt 1965 · S/N BA-728N929DVSiegfried Rand W · Sausalito, CABuilt 1954 · S/N BA-32N92WAAdamson Donald R · Lonoke, ARBuilt 1958 · S/N BA-379N930RGarrett David B · Polson, MTBuilt 1959 · S/N BA-438N933GMMartin Jonathan W · West Grove, PAS/N BA-533N9370ZHans Boat Works Inc · Visalia, CABuilt 1954 · S/N 52-10850
Back to AD 75-27-09 R2