OpenAirDocs.org
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.

N10065Johnson Kyle · Exira, IABuilt 1949 · S/N 830N100HTMitchell Brian N · Scottsdale, AZBuilt 2010 · S/N 2N10175Bassett Donald J · Midland City, ALBuilt 1954 · S/N 1272N101MFUsda Forest Service Fepp · Trenton, NJBuilt 1957 · S/N 1953N1023VPeterson Chester L · Willis, TXS/N 2021N10BUKitzmiller Douglas A · Punta Gorda, FLBuilt 1953 · S/N 666N10RNExecutive Jet A LLC · Danbury, CTBuilt 1948 · S/N 2229N1101VClement Walter F · Enfield, NCBuilt 1947 · S/N 18N12087Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 734N12220Dixon Craig S · Rimrock, AZBuilt 1958 · S/N 2267N125MRBlue Ridge Helicopters LLC · Martinsville, VABuilt 1957 · S/N 687N12888Suess Robert D · San Jose, CABuilt 1947 · S/N 20N130VJ Bird Air Service LLC · Cheyenne, WYBuilt 1958 · S/N 2230N13298Lidija LLC · Grass Valley, CAS/N 1346N132BRSteinheiser Terry N · Renfrew, PABuilt 1951 · S/N 51-332N13ASScholem Paul F · Rutherfordton, NCBuilt 1954 · S/N 1110N140BL Bachman LLC · Independence, IABuilt 1947 · S/N 60N147CGMagic Carpet Ride Aviation LLC · Columbus, OHBuilt 1956 · S/N 1044N147DPWeeks Kermit A · Polk City, FLBuilt 1956 · S/N 1685N147SMMazar Stephen M · Flushing, MIBuilt 1956 · S/N 1461N15395Magnum Aviation LLC · Goff, KSS/N 2408N153BScotts Helicopter Service · Le Sueur, MNBuilt 1947 · S/N 7N155JNAero-Mobil Inc · Wilmington, DEBuilt 1955 · S/N 1445N157BLewis Gerald K · Bakersfield, CABuilt 1947 · S/N 11N160BJames David R · Wayne, MIBuilt 1947 · S/N 14N16356Modern American Warrior Inc · Spring, TXBuilt 1951 · S/N 536N17611Tc 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 YH49N200KVPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1960 · S/N 2258N202CHBavarian Barnstormers 2 Inc · North Fort Myers, FLBuilt 1951 · S/N 301N210BL & L Delivery Ltd · Romulus, MIBuilt 1975 · S/N 76N2199Heritage Flight Museum · Burlington, WABuilt 1952 · S/N 604N225BHammock Flying Service Inc · Smithville, ARBuilt 1949 · S/N 149N2292BMy Way LLC · Missoula, MTBuilt 1957 · S/N 1972N22APGospel Ministries International Inc · Collegedale, TNS/N 1144N22SHBryan Robert C · Waller, TXBuilt 1952 · S/N 52-7953N237DJJames David R · Wayne, MIS/N 237N24067Pearce Michael J · Phoenix, AZBuilt 1953 · S/N 1220N2469BKothman Kenn Kode · Sheffield, TXS/N 1446N2473BKerr Douglas E · Oakland, CABuilt 1955 · S/N 1450N2476BClaridge Joseph M · Somis, CABuilt 1956 · S/N 1365N2480BWillert Fred J · San Diego, CABuilt 1955 · S/N 1360N2490BExperimental Acft Assoc Inc · Oshkosh, WIBuilt 1956 · S/N 1516N2507X4 Star Aviation Inc · Jefferson City, MOS/N 6073N250894 Star Aviation Inc · Jefferson City, MOS/N 6078N2508K4 Star Aviation Inc · Jefferson City, MOS/N 6076
Back to AD 75-18-06