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.

N38BWRed Cloud Aviation LLC · Shawnee, OKBuilt 1965 · S/N BA-725N38WSilverbird Vintage Aircraft & Flying Services LLC · Zeeland, MIBuilt 1960 · S/N BA-580N390VKuehler Jon · Amarillo, TXS/N BA-419N40074American Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1954 · S/N AF 834N400KUGudgel Daniel R · Lemoore, CABuilt 1961 · S/N BA-572N40189Jacob Mark K · East Lansing, MIBuilt 1943 · S/N 51218N404CKN404ck LLC · Anchorage, AKBuilt 1953 · S/N AF-297N404HMid Atlantic Air Museum · Reading, PABuilt 1961 · S/N BA-590N404TGreatest Generation Naval Museum · Colorado Springs, COBuilt 1959 · S/N BA-432N408THKestrel/Hyline · West Des Moines, IABuilt 1955 · S/N BA-110N40JTTct Aerial LLC · Waukesha, WIBuilt 1952 · S/N CA-128N41005Farwell Jesse R · Albion, NYBuilt 1943 · S/N 51236N411JAukes Brian E · Huxley, IABuilt 1953 · S/N A-967N41289Nizex Inc · Jackson, GAS/N A-475N412KKourtis Vintage Aviation LLC · Owasso, OKBuilt 1946 · S/N A-263N418GBClaire Aviation Inc · Wilmington, DEBuilt 1944 · S/N 76755N4207American Airpower Hrtg Flg Museum · Dallas, TXBuilt 1943 · S/N 67124N42114Spiller Gary W · Lafayette, ORS/N 39815N42CStage One Associates LLC · Oxford, CTS/N A-468N42DMajerle Michael A · Big Lake, AKS/N BA-117N4356GTop Hand Inc · Laurel, MTBuilt 1951 · S/N CA56N43927Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N A-26N44573Adventure North Flying Service LLC · Baudette, MNBuilt 1944 · S/N 7678N44607Shepard Group LLC · Mena, ARBuilt 1945 · S/N A-15N44638Vintage Aircraft Inc · Stockton, CAS/N A-45N4477Parish John Sr · Tullahoma, TNBuilt 1952 · S/N A-935N447DMMorlock Inc · Crossville, TNS/N AF269N450TAKestrel Inc · West Des Moines, IABuilt 1959 · S/N BA-482N45CFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1959 · S/N BA466N45GCAshworth Corp Inc · Geneseo, NYBuilt 1954 · S/N AF-469N45SKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N AF-645N471CMMartin-Remesz Michele · Boca Raton, FLBuilt 1955 · S/N BA-76N476PASilver Wings Flying Company LLC · Olympia, WAS/N CA-265N47GLaunder Brian L · Tulsa, OKBuilt 1957 · S/N BA-289N480PPlane Fun Inc Tr Trustee · Snellville, GAS/N 52-10885N48MGarrison William E · Nickerson, KSBuilt 1996 · S/N BA-155N4910NJackson James E · Brainerd, MNS/N 8382N491DMRst Aviation LLC · Vero Beach, FLBuilt 1952 · S/N 52-10643N49265American Airpower Heritage Flying Museum · Dallas, TXBuilt 1943 · S/N 39265N496DMGoff Richard A · Plevna, MTS/N AF-298N4DHGlenn L Martin Maryland Aviation Museum · Baltimore, MDBuilt 1946 · S/N A-260N50225Mayes John · Carson City, NVS/N BA-619N502DDWaller County Aviation Museum · Brookshire, TXBuilt 1960 · S/N BA-542N50WAClements Bruce · The Villages, FLBuilt 1962 · S/N BA-616N5180VSunzeri Jeffery J · Hollister, CABuilt 1959 · S/N 51-11689AN52DNAir Apparent Aviation LLC · Plant City, FLBuilt 1952 · S/N A-846N54CXIsland City Seaplanes Inc · Cordova, AKBuilt 1956 · S/N BA-175N54KLumley William B · Delray Beach, FLBuilt 1957 · S/N BA-235N5552AAllen Chorman & Son Inc · Milton, DEBuilt 1944 · S/N 8431N555WSDeer Creek Dusters Inc · Rolling Fork, MSBuilt 1956 · S/N BA-168
Back to AD 75-27-09 R2