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.

N733QXVaughan Stephen D · Finchville, KYBuilt 1976 · S/N 17268476N733QYKlassen Harvey L · Springport, MIBuilt 1976 · S/N 17268477N733QZHogan Robert P · North Pole, AKBuilt 1976 · S/N 17268478N733RWalsh John J · Atkinson, NHS/N 733N733RALilly Daryl A · Winterset, IABuilt 1976 · S/N 17268479N733RDSzoke Thomas L · Walnutport, PABuilt 1976 · S/N 17268482N733RFBaymax Aviation LLC · Ronkonkoma, NYBuilt 1976 · S/N 17268484N733RJMarti Jed B · Salt Lake City, UTBuilt 1976 · S/N 17268179N733RNLugert David C · Placerville, CABuilt 1976 · S/N 17268491N733RT661pc LLC · New Rockford, NDBuilt 1977 · S/N 17268496N733RUShogbonyo Michael A · Arlington, TXBuilt 1977 · S/N 17268497N733RVHanley Thomas W · Kissimmee, FLBuilt 1977 · S/N 17268498N733RWGeterdun LLC · Stowe, VTBuilt 1977 · S/N 17268499N733RYGeaux Giddum 1 LLC · Brandon, MSBuilt 1977 · S/N 17268501N733SBWalker Andrew · Knoxville, TNBuilt 1977 · S/N 17268504N733SFBurr Ralph C · Smyrna, GABuilt 1977 · S/N 17268507N733SHChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12735N733SKRcs Services LLC · California, MDBuilt 1977 · S/N 17268511N733SLHardin John M · Terrell, TXBuilt 1977 · S/N 17268512N733SURosas Milton A · Kingsburg, CABuilt 1977 · S/N 17268519N733SVBeard Mark S · Decker, INBuilt 1977 · S/N 17268520N733SXTrimble Richard L · Forest City, IABuilt 1977 · S/N 17268522N733SYDoutt Gerald G · Kalamazoo, MIBuilt 1977 · S/N 17268523N733TCFlores Omar J · New Braunfels, TXBuilt 1977 · S/N 17268527N733TDFrantzen Elizabeth · Davie, FLBuilt 1976 · S/N 17267136N733TERedtail Partners LLC · Moab, UTBuilt 1977 · S/N 17268529N733TJFenton Earl · Puyallup, WABuilt 1977 · S/N 17268533N733TKCardiff Aviation Inc · Cardiff By The Sea, CABuilt 1977 · S/N 17268534N733TLRising Wings Aviation Inc · Casper, WYBuilt 1977 · S/N 17268535N733TPR&R Aero Services LLC · Eden Prairie, MNBuilt 1977 · S/N 17268538N733TQCarmel Aviation Inc · Boise, IDBuilt 1977 · S/N 17268539N733TRWenatchee Sport Flyers · Wenatchee, WABuilt 1977 · S/N 17268540N733TSCox Eileen Xiomara · Davie, FLBuilt 1977 · S/N 17268541N733TTTeens In Flight Inc · Palm Coast, FLBuilt 1977 · S/N 17268542N733TUChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12734N733TVTempleton Bros Construction LLC · Livingston, TXBuilt 1977 · S/N 17268544N733TXKelley Aircraft LLC · Weyers Cave, VABuilt 1977 · S/N 17268545N733UAMergen John F · Baltimore, MDBuilt 1977 · S/N 17268548N733UBKale Larry · Rogers, OHBuilt 1977 · S/N 17268549N733UCSorbi Aviation Inc · El Cajon, CABuilt 1977 · S/N 17268550N733UDSpinks Flight Center Inc · Burleson, TXBuilt 1977 · S/N 17268551N733UFReid Dennis · Vinemont, ALBuilt 1977 · S/N 17268553N733UGHoffman Thomas A Trustee · Emmett, KSBuilt 1977 · S/N 17268554N733UJEngelhard Edward L · Hatfield, PABuilt 1977 · S/N 17268556N733UTOmartian Robert A · Simsbury, CTBuilt 1977 · S/N 17268565N733VADrane Kenneth · Natchez, MSBuilt 1977 · S/N 17268572N733VFGillen Scott E · San Diego, CABuilt 1977 · S/N 17268577N733VGFrevert Darwin C · Highland Village, TXBuilt 1977 · S/N 17268578N733VHAerospace Testing Engineering & Certification Inc · Seattle, WABuilt 1977 · S/N 17268579N733VJLura Aaron P · Carrington, NDBuilt 1977 · S/N 17268580
Back to AD 81-18-04 R2