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.

N706BHSilver Lance Aviation LLC · Ketchum, IDBuilt 2006 · S/N 2354N706CUsda Aphis Ws · Cedar City, UTBuilt 2009 · S/N CC18-0039N706CBMetal Feathers Inc · Ovilla, TXBuilt 2008 · S/N 72847N706CFRegistered aircraftBuilt 1963 · S/N 127N706DAFlycarolina LLC · Charlotte, NCBuilt 1980 · S/N 17274339N706DEBradley Aircraft Company LLC · Columbus, INBuilt 1979 · S/N 17272596N706FLTime Flys Idaho LLC · Clarkston, WAS/N 28-7225300N706HPFlorida Highway Patrol · Tampa, FLBuilt 1985 · S/N R18202013N706JJJj Helicopters Inc · Torrance, CABuilt 2008 · S/N 4306N706KSSzmania Kris J · Rossford, OHBuilt 1987 · S/N 706N706LA4 Winds Consulting LLC · Nashua, NHBuilt 1995 · S/N 003N706LGRegistered aircraftBuilt 1972 · S/N AA1A0414N706LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11472N706MU S Dept Of The Interior · Boise, IDBuilt 2005 · S/N 52N706MCSt Bernard Parish Government · Chalmette, LABuilt 1980 · S/N 883N706NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2018 · S/N 2881023N706QRegistered aircraftBuilt 2017 · S/N 82588N706RAChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843899N706RPPuckett Rex L · Silver Creek, GABuilt 2008 · S/N 81244N706SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13576N706TGauntlett Robert Michael · Yukon, OKS/N TTN75N706TBMha Flying LLC · Annapolis, MDBuilt 2000 · S/N 2034N706UBMaliskey Paul D · Au Gres, MIBuilt 1970 · S/N 18-8912N706WCChilcott Bart L · Derby, KSBuilt 1965 · S/N 647N7070GGade Christopher P · Williston, VTFirst renewal noticeBuilt 1969 · S/N 17258770N7070PHytry Randal G · De Soto, WIBuilt 1960 · S/N 24-2222N7070RRegistration Pending · Seward, NERegistration pendingBuilt 1966 · S/N 28-21771N7070VCraven Bradley A · Logansport, INBuilt 1976 · S/N 20-1207N7070WFullerton Brice · Oroville, WAS/N 28-849N7070YBean James P · Tulsa, OKBuilt 1963 · S/N 30-83N70714State Of Alaska · Anchorage, AKBuilt 1979 · S/N 18-7909114N70718Youkey John N · Yuma, AZBuilt 2003 · S/N 037N7071GWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258771N7071JMorales Felipe E · San Antonio, TXBuilt 2003 · S/N 2356N7071PNelson Harold G · Pendleton, ORBuilt 1960 · S/N 24-2223N7071QSun Country Aero Club · The Villages, FLS/N 17260371N7071RKarabulut Semih · North Little Rock, ARS/N 28-21772N7071WTeigen Travis S · Glenwood City, WIBuilt 1962 · S/N 28-851N7071YJts Aircraft LLC · Rock Hill, SCS/N 30-84N7072BJenema Jerry W · Lake City, MIS/N 18-5147N7072GMears Benjamin W III · Eastville, VABuilt 1969 · S/N 17258772N7072KElliott Troy D · Star, IDBuilt 1950 · S/N 20-178N7072LPolsin Thomas H · Lowell, WIBuilt 1993 · S/N 05N7072PRegistration Pending · Kalispell, MTRegistration pendingBuilt 1960 · S/N 24-2224N7072QB&R Aircraft LLC · Wadsworth, OHS/N 17260372N7072RMckinley Matthew R · Sault Sainte Marie, MIS/N 28-21773N7072WNelson David L · Laporte, INBuilt 1962 · S/N 28-852N70739Morey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 15282595N7073BHerman Seth J · Brookville, PABuilt 1956 · S/N 18-5148N7073GSky Warriors LLC · Hayward, CAS/N 17258773
Back to AD 81-18-04 R2