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.

N9281KBartels Aviation LLC · Merritt Island, FLBuilt 1976 · S/N 28-7615192N9281MJakobsen Anders M · Norcross, GAFirst renewal noticeBuilt 1966 · S/N 3463N9281RBmg Aviation Leasing LLC · Bloomington, INBuilt 1978 · S/N R18200678N9281SBmc2 LLC · Phoenix, AZBuilt 1976 · S/N M-1790N9281VJohnson Jerry W · Westlake, TXBuilt 1969 · S/N 690077N9282CRegistration Pending · Augusta, KSRegistration pendingBuilt 1978 · S/N 28-7816455N9282FBox Helicopters Inc · Cotulla, TXBuilt 1974 · S/N 340289N9282MRainey Michael N · Cleveland, TNBuilt 1966 · S/N 3464N9282PCampbell Paul · Glade Spring, VABuilt 1968 · S/N 24-4782N9282SMorgan John S · Athens, ALBuilt 1974 · S/N M-1624N92837Staszak Sandra · Martinsville, ILBuilt 1973 · S/N 17261631N9283AFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12788N9283JN9283j LLC · Boise, IDBuilt 1966 · S/N 28-3363N9283MHazelswart India A · Chase City, VABuilt 1966 · S/N 670001N9283SRegistration Pending · Johnson City, TNRegistration pendingBuilt 1975 · S/N M-1625N9283WJohnson Mark A · Norfolk, NEBuilt 1967 · S/N 28-10959N92845Hainet Aero LLC · Wilmington, DEBuilt 1973 · S/N 17261633N9284AGriffith Nathan · Boston, MABuilt 1985 · S/N 28-8616041N9284KMtm Aviation LLC · Lake Havasu City, AZBuilt 1976 · S/N 28-7615193N9284LWilkins Perry · Chesapeake, VABuilt 1971 · S/N AA1A-0184N9284MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1985 · S/N 28-8616042N9284PDickinson Malcolm · Stamford, CTBuilt 1968 · S/N 24-4784N9284STamad Aviation LLC · Tracy, CABuilt 1975 · S/N MC-329N9284TGarrett Randall F · Fort Walton Beach, FLBuilt 1978 · S/N 38-78A0319N9284VBloomer Garett · Ballston Lake, NYBuilt 1969 · S/N 690064N9284WGutierrez Daniel M · Kennett Square, PABuilt 1967 · S/N 28-10960N9284ZFlex Aircraft Leasing Co LLC · Detroit, MIBuilt 1997 · S/N 3246064N9285November 9285 LLC · Higden, ARBuilt 1978 · S/N 1003N92855Falcon Flying Club · Mesa, AZBuilt 1973 · S/N 17261634N9285CSunset Flights LLC · Azusa, CABuilt 1978 · S/N 28-7890396N9285HOrion Aviation Aircraft LLC · Carlsbad, CABuilt 1975 · S/N 17266068N9285JCope Jarret C · Lexington, NCS/N 28-3369N9285M5 M Leasing LLC · Englewood, COBuilt 1985 · S/N 28-8616043N9285PStumpf Bernard L · Westerly, RIBuilt 1968 · S/N 24-4785N9285VEllsworth Bryan E · Garden City, UTS/N 690079N9285YUeeck Brett A · Anchorage, AKBuilt 1971 · S/N 18-8919N9286Drent Ethan M · Greenwood, INS/N 165N9286DCaldwell Bob · Columbus, MSBuilt 1958 · S/N 18-6592N9286FFlying High Like A Bird In The Sky · Longwood, FLBuilt 1974 · S/N 1040368N9286MWiley Aviation LLC · Murfreesboro, ARBuilt 1985 · S/N 28-8616044N9286TMccabe Robert C Jr Trustee · Santa Rosa Beach, FLBuilt 1996 · S/N 11247N9286VRupinski Casimir Michael III · Cape May, NJBuilt 1969 · S/N 690080N9286WAmigos Flight Club LLC · Schertz, TXBuilt 1967 · S/N 28-10962N92873Sonday Terrance P · Spring, TXBuilt 1973 · S/N 17261636N92878Jackson Richard L · Indianapolis, INBuilt 1973 · S/N 17261638N9287ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 1997 · S/N 2842019N9287MRkm Leasing LLC · Greenwich, CTBuilt 2011 · S/N 172S11112N9287SDale Michael W · Clayton, NCS/N MB-758N9287VRuschman Vaughn M · Boise, IDBuilt 1969 · S/N 690080N92886Lewis John E · Clayton, NJBuilt 1973 · S/N 17261640
Back to AD 81-18-04 R2