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.

N8281YReined Out LLC · Nantucket, MABuilt 1980 · S/N 328106003N82829Wingin It 13 LLC · Middletown, NYBuilt 1980 · S/N 28-8111015N8282JHoover Michael B · Ridgeland, WIBuilt 1979 · S/N VAC-128-79N8282VEnsemble Air LLC · Laramie, WYBuilt 1980 · S/N 28-8116060N8282WBenker Albert J · Bevier, MOBuilt 1965 · S/N 28-2440N82832Stokke Todd · Magnolia, TXBuilt 1980 · S/N 28-8190066N82836Aerodreams Aviation LLC · Raleigh, NCBuilt 1980 · S/N 28-8190071N8283BFatiha Anouar · Columbus, INBuilt 1980 · S/N 28-8111016N8283JFurey Gale J · Bedford, NHBuilt 1979 · S/N VAC-129-79N8283NRuth Joyce Aviation LLC · Henderson, TXBuilt 1969 · S/N 28-25499N8283PPolzin Thomas H · Chippewa Falls, WIBuilt 1963 · S/N 24-3535N8283VMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 28-8116065N8283YPhillips Thaddus L · Knoxville, TNBuilt 1980 · S/N 28-8190064N8284JCrouch Scott M · Steamboat Springs, COBuilt 1979 · S/N VAC-130-79N8284NHolland Alan L · Houston, TXBuilt 1969 · S/N 28-25501N8284PTonry Richard Martin · Georgetown, TXBuilt 1963 · S/N 24-3536N8284WCaldwell Darrel R · Panama City Beach, FLBuilt 1965 · S/N 28-2443N8284YKahnke Richard Joseph · Mankato, MNBuilt 1980 · S/N 28-8111019N82859Schoeler George A · Ocala, FLBuilt 1980 · S/N 28R-8118018N8285BHyldburg Aviation Inc · Plymouth, MABuilt 1980 · S/N 28-8116066N8285EJames G Loy General Contractor Inc · Punta Gorda, FLBuilt 1979 · S/N 17272171N8285PPhillips Dale J · Michigan City, INBuilt 1963 · S/N 24-3537N8285WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2446N8285YAmerican Aviation Inc · Woods Cross, UTFirst renewal noticeBuilt 1980 · S/N 28-8190073N82864Meyer Fredric Kim · Orange, CABuilt 1982 · S/N 28-8316005N8286CMidwest Sky Chasers Nfp · Algonquin, ILBuilt 1975 · S/N 28-7690110N8286EPreston Richard R Trustee · Albuquerque, NMBuilt 1979 · S/N 17272172N8286NAyyildiz Erol · Glen Rock, NJBuilt 1969 · S/N 28-25503N8286PStage Crew LLC · Clermont, FLBuilt 1963 · S/N 24-3538N8286RHuhnke John F · Newburgh, INBuilt 1999 · S/N 103N8286YCoub Industries Inc · Fairfield, CABuilt 1967 · S/N 30-1422N8287Holloway Earnie G · Bonner Springs, KSBuilt 1972 · S/N 5231931N8287BCostanti Nicolas J · Medford, ORS/N 18-7609048N8287JBurnett Stephen B · Granby, MOBuilt 1979 · S/N VAC-133-79N8287NBetik Patrick G · Grapevine, TXS/N 28-25504N8287PDeviny William M Jr · Arroyo Grande, CABuilt 1963 · S/N 24-3539N8287YLocust Hill Aviation LLC · Lewes, DEBuilt 1980 · S/N 28-8111020N8288AJohnson Carmen · White Cloud, MIBuilt 1982 · S/N 28-8390020N8288CRood James D · Winston, NMBuilt 1955 · S/N 18-4113N8288EGomez Cierra D · Jasper, ALS/N 17272174N8288FAtwood Jason P · La Porte, INBuilt 1976 · S/N 28-7790237N8288JRegistration Pending · Oklahoma City, OKRegistration pendingBuilt 1979 · S/N VAC-134-79N8288LFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1980 · S/N 28R-8118011N8288PStelter John · Clancy, MTBuilt 1963 · S/N 24-3540N8288ZPabon Hugo · Granada Hills, CABuilt 1980 · S/N 28-8116071N8289AAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 28-8116072N8289CSchilder Justin W · Faulkton, SDBuilt 1954 · S/N 18-3699N8289GDutcher Kenneth J · Kingsland, TXS/N 177RG0189N8289JCummings Steven R · League City, TXS/N VAC-135-79N8289XSheitelman Mitchell · Warren, NJBuilt 1980 · S/N 28-8190080
Back to AD 81-18-04 R2