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.

N102SAKestrel Inc · West Des Moines, IABuilt 1959 · S/N BA-441N103GClifford Michael P · Paris, TXBuilt 1950 · S/N A533N1047BAlaska Aviation Museum · Anchorage, AKS/N 7728N1140Beechboys Aviation LLC · Wilmington, DEBuilt 1946 · S/N A-129N11863Schwendenman Zachary M · West Covina, CAS/N 51-11863AN118DJInternational Air Services Inc Trustee · Carson City, NVBuilt 1943 · S/N 43-35634N118SAReid Marici P · Independence, ORS/N BA-14N121SCNorth Bay Air Museum · Sonoma, CABuilt 1946 · S/N A-85N122GSDixie Aviation Enterprises LLC · Gallatin, TNBuilt 1979 · S/N BA-259N125MBLewallen William J · Arizona City, AZBuilt 1942 · S/N AF-286N12718Pack Backers LLC · Clinton, NCS/N 39750N12719Tilghman Charles R Jr · Van Alstyne, TXBuilt 1944 · S/N 51125N127MLNiemyjski Justin · Franksville, WIBuilt 1946 · S/N A-212N136JJMyers Jonathan A · Dieterich, ILBuilt 1957 · S/N BA-318N13JCVintage Flying Museum Inc · Fort Worth, TXBuilt 1954 · S/N BA-31N1400EDynamic Avlease Inc · Bridgewater, VABuilt 1956 · S/N BA-227N141ZAVintage Flying Machines Inc · Huntington, INS/N BA-178N144NBWiley C Sanders Jr · Troy, ALBuilt 1955 · S/N BA-39N145AZAmerican Airpower Heritage Flying Museum Inc · Dallas, TXS/N A-235N145JMelton Ricky N · Luttrell, TNBuilt 1943 · S/N 51233N1480KTheberge Jane A · Oakland Park, FLBuilt 1961 · S/N BA-601N14PWAudemus Inc · Newport News, VAS/N AF-314N150PRAerojet Servivces Inc · Aurora, COS/N AF-382N152CJ & N Endeavors LLC · Wilmington, DEBuilt 1944 · S/N 51116N15810Walker Matthew James · Henderson, NVBuilt 1935 · S/N 62N1597Registration Pending · Laguna Beach, CARegistration pendingBuilt 1953 · S/N AF-527N165XRock Air LLC · Wilmington, DEBuilt 1956 · S/N BA-189N165ZAHoffman Carl A · Newnan, GABuilt 1953 · S/N AF543N167ZAAgather V Neils · Fort Worth, TXBuilt 1954 · S/N AF-692N16CLBig Sky Aviation · Wilmington, DEBuilt 1955 · S/N BA-67N1801DKlaers Lawrence B · Waconia, MNBuilt 1952 · S/N A-816N1828DWalker Matthew James · Henderson, NVBuilt 1952 · S/N A-837N184KPPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N CA-130N1850North Shore Aviation Services Corp · Waialua, HIS/N AF744N189RHoughton Justin · North Ferrisburg, VTBuilt 1962 · S/N 51-11766N18BY18by LLC · Hood River, ORBuilt 1957 · S/N BA-275N18DTriple Four Mike LLC · Ponte Vedra Beach, FLS/N AF-29N18ESchultz Philip W · Lancaster, CABuilt 1958 · S/N BA-383N18G416wy LLC · Sheridan, WYBuilt 1959 · S/N BA-469N18LGGayler George Larry · Thermal, CABuilt 1956 · S/N BA-181N18RWBeechballz LLC · Port Orange, FLBuilt 1963 · S/N BA-653N18RYYounkin Matthew A · Siloam Springs, ARBuilt 1957 · S/N BA-325N18SEShores Ag Air Inc · Robstown, TXBuilt 1956 · S/N BA-186N18XWEastern Stearman Inc Trustee · Leesburg, VAS/N CA191N1939KCrazy Woman LLC · Tupelo, MSS/N BA403N197LAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1947 · S/N A-361N200KUMilitary Aircraft Restoration Corp · Costa Mesa, CABuilt 1946 · S/N 67103N2069CAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1959 · S/N BA-430N21011Lucy Donald Edwin III · Newbury Park, CABuilt 1957 · S/N BA-292N210QSkydog Air LLC · Lexington, SCBuilt 1957 · S/N BA-291
Back to AD 75-27-09 R2