AD 75-18-06

Registered aircraft · 212

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-18-06')
    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-18-06')
  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.

N47HSJames David R · Wayne, MIBuilt 1956 · S/N 883N47MHWheatley Lester E Jr · Priest River, IDS/N 2025N47WFCantarini Cody M · Fallbrook, CABuilt 1966 · S/N T-610N47ZAGanuza Diego · North Miami Beach, FLBuilt 1956 · S/N 1533N5162BK D Helicopters Inc · Shingleton, MIFirst renewal noticeBuilt 1957 · S/N 1980N5167BStills Inc · Ashville, ALBuilt 1957 · S/N 1996N5172BJames David R · Wayne, MIBuilt 1957 · S/N 2008N547SBSequeira Michael J · Troy, MOBuilt 1954 · S/N 5N555DScotts Helicopter Services Inc · Le Sueur, MNBuilt 1956 · S/N 1478N555ENSetnar Stephen R · Butler, PABuilt 1947 · S/N 6N568TBWhite Thomas J · Agua Dulce, CAS/N 85N5990Aaa Aerial Solutions LLC · Dassel, MNS/N 2396N59HAircraft Sales LLC · Caledonia, MIBuilt 1951 · S/N 325N5HAmerican Helicopter Museum And Education Center · West Chester, PABuilt 1946 · S/N 3N6140CNorth Coast Helicopter Service Inc · Napa, CABuilt 1948 · S/N 47N6141Black Shadow Aviation Inc · Georgetown, FLS/N 1506N614ATBall Alexander R · Norco, CAS/N 2432N6173Whirlybirds LLC · Monroe, CTS/N 2253N617XDavis Lloyd L Jr · Brackettville, TXBuilt 1965 · S/N C-5016N61ARAircopters Of San Diego Inc · El Cajon, CAS/N 2099N62221Lundell Levi T · Bolling Afb, DCBuilt 1947 · S/N 16N6327DJohafe Aviation LLC · Wilmington, DEBuilt 1952 · S/N 828N63300Bassett Tommy J · Ashford, ALBuilt 1951 · S/N 841N6355Stewart Robert D · Farmington Hills, MIBuilt 1956 · S/N 1670N6356Eagal Lloyd S · Renfrew, PABuilt 1956 · S/N 1671N6356XPleasant Aviation LLC · Mount Pleasant, TXBuilt 1963 · S/N CCI-563N6359XKiob LLC · Lexington, KYBuilt 1963 · S/N 64-010RN6520Henry Mark A · Dickinson, TXBuilt 1954 · S/N 54-4034N6521Henry Mark A · Dickinson, TXBuilt 1955 · S/N 55-4113N65520Sale Reported · Troy, MOSale reportedBuilt 1957 · S/N 2012N6579DIxl Inc · Sulphur, LAS/N 895N6597DHeli Flite Inc · Corona, CAS/N 1017N6707DMines Keith A · White Cloud, MIBuilt 1958 · S/N 2187N6711DAnderson Christopher T · Janesville, WIBuilt 1958 · S/N 2192N6720DNorthwind Hilos LLC · Schoolcraft, MIBuilt 1958 · S/N 2204N6744DDyer Randall J · Frazier Park, CAS/N 2238N6749DCj Air LLC · Nezperce, IDBuilt 1959 · S/N 2240N6750DMorten Jesse L · Larimore, NDBuilt 1959 · S/N 2241N6758DCaruso Dennis · Saint Marys, PAS/N 2249N6774DSouthern Cross Aviation · Wilmington, DES/N 2450N6776DMilam Inc · Trussville, ALBuilt 1959 · S/N 2439N68GRMagnum Aviation LLC · Goff, KSS/N 7401N69GRMagnum Aviation LLC · Goff, KSS/N 8646N701GRMagnum Aviation LLC · Goff, KSS/N 7408N703GRMagnum Aviation LLC · Goff, KSS/N 7406N7081UHhi Farms LLC · Hamilton, MIS/N 1913N7137ZGreenway Michael D · Friday Harbor, WABuilt 1948 · S/N 19N74004House Guy C · Castle Creek, NYBuilt 1951 · S/N 403N74005Newton Property Leasing LLC · Greene, IABuilt 1963 · S/N 409N74081Kehoe Keith J · Marion, TXS/N 216
Back to AD 75-18-06