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.

N902APPollard Aircraft Sales Inc · Fort Worth, TXBuilt 1998 · S/N 18280306N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902CWhite Edwin W · Eagle River, AKBuilt 2001 · S/N 2162N902CCVan Flve Klub Inc · Holt, MNS/N 9902CCN902EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12964N902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902FCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842174N902GRWright Allan M · Los Gatos, CABuilt 2002 · S/N 2411N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N902PADefranco Peter Jr · Hueytown, ALBuilt 2002 · S/N 2843530N902SAWild Wings Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N SH001N902SCCampbell Steven · Tipp City, OHBuilt 2021 · S/N 067N90309Roe David N · Santa Fe, NMBuilt 2007 · S/N 81049N9030FDesouza Ferdinand E · El Prado, NMS/N 454N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058N9030LDavis Robert L · Seymour, TNBuilt 1970 · S/N 216-70N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059N9031LSanderlin Doulgas C · Wasilla, AKBuilt 1970 · S/N 253-70N90322State Of Alaska Department Of Public Safety · Anchorage, AKS/N 20608323N9032CGoodman Kim J · Burnsville, NCBuilt 1978 · S/N R18200377N9032LJohnson Robert W · Buffalo, SDBuilt 1970 · S/N 259-70N9032WPringle Craig Marlin · Winfield, KSS/N 28-10624N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062N9033LBickmore David L · Bay City, MIBuilt 1970 · S/N 260-70N90343Kay R Steven · Riverside, CABuilt 1979 · S/N DAL 78R1N90346Mittelsted John J · Dickinson, TXBuilt 1967 · S/N 27-3604N90347R & S Aircraft LLC · Wilmington, DEBuilt 1946 · S/N 361N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063N9036BVan Bortel Aircraft Inc · Arlington, TXBuilt 2010 · S/N 18282258N9036DKranz Monte L · Eagle Butte, SDBuilt 1958 · S/N 22-6174N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066N9036KGriffiths Gregory S · Johnson City, NYBuilt 1977 · S/N 28-7816184N9036LWhitmer Charles W · Fairbanks, AKBuilt 1970 · S/N 264-70N9036NRobinson Helicopter Co · Torrance, CABuilt 1981 · S/N 0089N9036RBaltz David M · Superior, COBuilt 1978 · S/N R18200658N90371Jackson Thomas M · Mckinney, TXS/N 385N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067N9038DJones Michael D · Eagle River, AKBuilt 1958 · S/N 22-6176N9038FGrupp Wayne · Wayne, ILBuilt 2006 · S/N 1N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N9038KNorthwest Aviation LLC · Gig Harbor, WABuilt 1977 · S/N 28-7816185N9038YRodriguez Juan M · Grass Valley, CABuilt 1983 · S/N FM2N90391Meyer Florence Trustee · Billings, MTBuilt 2010 · S/N 18282259N90392Parsons Walter E · Clinton, NCS/N 406N9039CDouble O Seven Limited Co · Carefree, AZBuilt 1978 · S/N R18200378N9039LBowman Eagles Inc · Louisville, KYBuilt 1970 · S/N 767-70N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327N903DRCrosgrove Shawn R · Riverton, UTBuilt 2013 · S/N 82372N903EESkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843229
Back to AD 81-18-04 R2