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.

N74084Boger Roger · Ludington, MIBuilt 1962 · S/N NH963N74120Slevin Mary Elizebeth · Altamont, NYBuilt 1949 · S/N WH5005N74124Bowles Alan B · Georgetown, TXBuilt 1963 · S/N WH-5009N74822Nockair Inc · Longboat Key, FLBuilt 1964 · S/N 456N74823Tobler Hans P · Anchorage, AKBuilt 1953 · S/N 270N74898James David R · Wayne, MIS/N AIAT-68N755ELavanture Richard A · Bristol, INBuilt 1951 · S/N 312N7730Gay Richard L · Middleville, MIBuilt 1968 · S/N K821N7732South Atlanta Helicopters LLC · Hampton, GABuilt 1965 · S/N T-514N7736Shank Brian · Manheim, PABuilt 1954 · S/N K-8129N7762Peterson Chester L · Spring, TXBuilt 1969 · S/N K931N7802EContinental Helicopters Inc · Mason, TXS/N 473N7887BLidija LLC · Grass Valley, CABuilt 1958 · S/N 2023N7888BMorten David J · Larimore, NDBuilt 1958 · S/N 2024N78900Master Designs LLC · Gilbert, AZBuilt 1952 · S/N 480N7893BDykstra Donald J · Dorr, MIBuilt 1958 · S/N 2029N7985AGiles Forrest D · Springtown, TXBuilt 1958 · S/N 1022N7ARAircraft Sales LLC · Caledonia, MIBuilt 1963 · S/N WH5001N8051EPatterson Casey Paul · Kinston, ALS/N TWH-15N80SQWatkins Arlo S · Chandler, AZBuilt 1959 · S/N 2522N8117Henry Mark A · Dickinson, TXBuilt 1967 · S/N K732N8236Horey Scott R · Ione, CABuilt 1955 · S/N 1333N8403EChurchill Scott W · Le Sueur, MNBuilt 1960 · S/N 2257N8409ED'Agostino Gerald J · Middleburg Hts, OHBuilt 1960 · S/N 2603N8428EWheatley Lester Edward Jr · Woodcrest, CAS/N 2476N8441EShore Stephen A · Elkin, NCBuilt 1960 · S/N 2609N8478DWood Denton A · Friendswood, TXBuilt 1957 · S/N 1697N8478HBertiling Brad · North Shore, CABuilt 1958 · S/N 2214N8520HVegas Baby! Lc · Royal Oak, MIBuilt 1980 · S/N OLYMPIC-01N855ETobler Hans P · Anchorage, AKS/N 41N8645GTobler Hans P · Anchorage, AKBuilt 1953 · S/N 822N88754Skypro Industries Inc · Jacksonville, FLBuilt 1953 · S/N 601N88755Old Time Ag Aviation LLC · Bakersfield, CAS/N 2252N88ARLumley William B · Delray Beach, FLBuilt 1957 · S/N 2046N8975Gauntlett Robert Michael · Yukon, OKS/N 607N9025Ocean Air Inc · Eugene, ORBuilt 1958 · S/N 2292N903BCosta James J · Tulare, CABuilt 1954 · S/N 847N90520Vanderbie Mark A · Hudsonville, MIBuilt 1979 · S/N WHL-61N90529Northland Helicopters Inc · Le Sueur, MNBuilt 1974 · S/N NT1958-1N908BPlevyak Malcolm S · Berwick, PABuilt 1952 · S/N 479N9115ROlson Robert L · Yuba City, CABuilt 1948 · S/N 93N9158RHaley Lee · Ahwahnee, CABuilt 1960 · S/N 455N917BQuatacker Matt · Porterville, CABuilt 1952 · S/N 606N921BAdkins Dwain L · Sycamore, ILBuilt 1952 · S/N 612N929BValiant Air Command Inc · Titusville, FLS/N 647N93067Milam Inc · Trussville, ALBuilt 1965 · S/N 5501N93175Gottschalk Brian D · Moscow, IDS/N 1000N932BCox William H Jr · Vacaville, CABuilt 1953 · S/N 665-1N9421HElliott Miles DBA · Porterville, CABuilt 1950 · S/N 178N950BIgwt Helicopters · Williford, ARBuilt 1954 · S/N 693
Back to AD 75-18-06