OpenAirDocs.org
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.

N510PCPaton Jamie D · Clearwater, FLS/N 1488N510RGGrubbs Randall D · Heber Springs, ARBuilt 2025 · S/N VANSRV10L54040791N510RKKnapp Russell · Groveland, FLBuilt 2024 · S/N 41162N510RVDeering Casey T · San Angelo, TXBuilt 2008 · S/N 40326N510SFGibson William V II · Aberdeen, MSBuilt 2008 · S/N 001N510SLBeery Roofing & Redesign LLC · Deland, FLS/N 18282153N510THRegistration Pending · Oxford, CTRegistration pendingBuilt 1975 · S/N 28R-7535221N510TRAltamira Flying Club Inc · Round Rock, TXBuilt 2003 · S/N 18281200N510UBoard Of Regents University Of Oklahoma · Norman, OKBuilt 2024 · S/N 4496588N51101Sweitz-Air Iinc · Stewartstown, PAS/N 23985N5110GN5110g LLC · Orlando, FLS/N 28-23211N5110HBuxton S · Mount Pleasant, SCBuilt 1948 · S/N 14-115N5110PGray William · Broken Arrow, OKBuilt 1958 · S/N 24-120N5110VDickson Chris A · Shelton, WABuilt 1962 · S/N 10N5110XT & M Aerial Spraying · Garland, NCBuilt 1969 · S/N 192N5111RAlpine Aviation LLC · Oasis, IDBuilt 1974 · S/N MB-645N5111SC And A Aviation Inc · Baltimore, MDBuilt 1971 · S/N 28-7105130N5111XJeter Michael C · Jacksboro, TXBuilt 1969 · S/N 664N5111ZSlaughter Don Wayne · Farmville, NCBuilt 1961 · S/N 22-8751N5112HDefendorf Nelson W · Anchorage, AKS/N 14-118N5112LRyan Lowe Aviation · Costa Mesa, CABuilt 1967 · S/N 28-4394N5112TStevens Richard N · Venice Center, NYBuilt 1966 · S/N 534N5112VMertz Harry Z · Castle Rock, COBuilt 1961 · S/N SP-12N5112WShulman Scott · Hillsborough, NHS/N 28-128N5113LTessos Air Service Inc · Wilmington, DEBuilt 1968 · S/N 28-5083N5113QTri-County Aviation LLC · Lawrenceburg, TNS/N 17261754N5113RHamaker Nevada C · Bothell, WABuilt 1974 · S/N MB-647N5113TSchaffner David A · Wray, COBuilt 1966 · S/N 516N5113XHemstock Ronn · Seward, AKBuilt 1969 · S/N 666N5113ZNielsen Jeffrey L · Harlan, IAS/N 22-8754N5114HReints Rydell J · Wasilla, AKBuilt 1948 · S/N 14-120N5114KParrillo Development And Real Estate LLC · Moorestown, NJBuilt 1980 · S/N 17273974N5114LHenry Lawrence D · Lohman, MOBuilt 1967 · S/N 28-4397N5114PParris David T · Virginia Beach, VABuilt 1958 · S/N 24-126N5114RHayden Steven E · Westminster, COBuilt 1974 · S/N MB-648N5114SConner W Larry · Los Lunas, NMBuilt 1971 · S/N 28R-7135148N5114THarlan Robert J · Kaycee, WYS/N 71N5114USilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1980 · S/N 172RG0243N5114ZMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10927N5115BWateractive43 LLC · Auburn, CAS/N 172S8987N5115EBarak David T · Mountain Home, IDBuilt 1978 · S/N 17271717N5115PSmith James Kelly · Newark, OHBuilt 1958 · S/N 24-127N5115RMichael D Woods LLC · Harleton, TXBuilt 1977 · S/N M-1974N5115SBridgeport Flying Club LLC · Bridgeport, CABuilt 1971 · S/N 28R-7135149N5115TTurkey Creek Aviation And Helicopter Service LLC · Uvalde, TXBuilt 1966 · S/N 137N5115UFournier Marc A · Jean, NVBuilt 1994 · S/N 1643N5115VGruber Thomas · Seattle, WABuilt 1961 · S/N SP-15N5115XArbaczauskas Stanislaus · Daphne, ALBuilt 1969 · S/N 167N5115ZSager Charles J Jr · Wofford Heights, CABuilt 1961 · S/N 22-8756N51163Christiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10930
Back to AD 81-18-04 R2