AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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.

N7250JBrandenburg Carl A Jr · Goodyear, AZBuilt 1968 · S/N 28-24592N7250PTrayer Kevin B Trustee · Haslet, TXBuilt 1961 · S/N 24-2426N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550N7250WHuber Peter Michael · Pulaski, VABuilt 1963 · S/N 28-1078N7251FWright Charles W · Selbyville, DEBuilt 1968 · S/N 28-25168N7251JChapman Michael S · Cardington, OHBuilt 1968 · S/N 28-24593N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952N7252JMedina Jose · Spring, TXBuilt 1968 · S/N 28-24594N7252KEgan Bailey J · Forsyth, MTBuilt 1950 · S/N 18-147N7252LForney Luke N · David City, NES/N AA1A-0452N7252PSchaefer Hugh W · Merrick, NYBuilt 1961 · S/N 24-2428N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552N7252SDorris Joseph · Lewisburg, KYBuilt 1999 · S/N 18280562N7252YGuyer James · Billings, MTBuilt 1964 · S/N 30-277N7252ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3184N72535Root Angelo R · Orovada, NVBuilt 1946 · S/N 9705N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953N7253JLeffler William J · Tucson, AZBuilt 1968 · S/N 28-24595N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553N7253WGross Matthew A · Ridgecrest, CABuilt 1963 · S/N 28-1081N7253YJednacz Scott T · Bixby, OKFirst renewal noticeBuilt 1964 · S/N 30-278N7254FWolf Kim A · East Wenatchee, WAS/N 28-25172N7254HVevani Aircraft LLC · Miami Gardens, FLBuilt 1999 · S/N 20608036N7254JMinkel Chad A · Chanhassen, MNBuilt 1968 · S/N 28-24597N7254KCook Tim L · Eagle River, AKBuilt 1950 · S/N 18-149N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554N7254WMonroe County Flyers And Sales LLC · Sweetwater, TNS/N 28-1083N7254YSpldkd LLC · New Richmond, WIBuilt 1964 · S/N 30-280N72551Gonzalez Christian · Manati, PRBuilt 1964 · S/N 28-10230N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031N72559Welch Paul · Oldsmar, FLBuilt 1999 · S/N 18280654N7255FN7255f LLC · Cedar City, UTBuilt 1968 · S/N 28-25173N7255JRury Bryan · Midlothian, TXBuilt 1968 · S/N 28-24598N7255LHall Travis J · Dayton, TNBuilt 1972 · S/N AA1A-0455N7255PKubik Rodrick D · Waukee, IAFirst renewal noticeS/N 24-2431N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555N7255ZCentral Ms Soaring Society LLC · Brandon, MSS/N 25-3189N7256FZihala William · North Little Rock, ARBuilt 1968 · S/N 28-25174N7256GAvstar Inc · Seattle, WABuilt 1999 · S/N 18280560N7256HChaparral Aviation LLC · Edmond, OKBuilt 1999 · S/N 18280556N7256LRegistration Pending · Fair Bluff, NCRegistration pendingBuilt 1972 · S/N AA1A-0456N7256QAustin Ferrel Stephen · West Monroe, LABuilt 1999 · S/N 18280552N7256WRoswall James B · Bristol, TNBuilt 1999 · S/N 18280507N7256YGupta Vivek · Shelton, CTBuilt 1999 · S/N 18280485N72579Allee Mark J · Gillette, WYBuilt 1967 · S/N 15067593N7257DArctic Aero LLC · North Pole, AKBuilt 1957 · S/N 22-5084N7257EAerospring Leasing LLC · Wasilla, AKBuilt 1999 · S/N 17280760N7257FHedberg Jacob R · Jordan, MNS/N 28-25175N7257JHardin John M · Terrell, TXBuilt 1968 · S/N 28-24601
Back to AD 81-18-04 R2