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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N515PUAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1983 · S/N 28-8316100 N515RDWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264049 N515SRegistration Pending · Azle, TXRegistration pending, pending cancellationS/N 24-3609 N515SDHoma Alex Michael · Ozark, ALBuilt 1977 · S/N C-1-1977 N515SED & H Equities LLC · Helena, MTBuilt 2006 · S/N 1019-2006 N515SKTurner Jereme K · Marietta, GABuilt 1994 · S/N 20028 N515SPFriedlander Ernest · San Francisco, CABuilt 2000 · S/N 172S8374 N515SRGifford Daniel · Fredericksburg, TXS/N AA5A-0799 N515TBMhoc LLC · Pensacola, FLBuilt 2009 · S/N 3074 N515TLLumpkin Theodore G III · Inglewood, CABuilt 2004 · S/N 3586 N515TRRabaut Charles P · Oceanside, CABuilt 2000 · S/N 5150 N515UDTumbleweed Leasing Company Inc · Salt Lake City, UTS/N 3515 N515VHGrabeklis Jay · Dallas, TXS/N 72090 N515VTBud E Aero Inc · Franklin Square, NYBuilt 1984 · S/N 28-8416100 N515VVGolden Age N515vv LLC · Norwalk, IABuilt 2025 · S/N 4496620 N515XCPlane Fun Inc Tr (Trustee) · Snellville, GABuilt 2016 · S/N CC19-0006 N515ZMcrae David B · Advance, NCBuilt 2020 · S/N 7911 N5160Historic Aircraft Restoration Museum · Maryland Heights, MOBuilt 1952 · S/N T1-6 N5160ELeading Edge Flight Academy LLC · Bend, ORBuilt 1978 · S/N 17271744 N5160HNiemi Danny L · Osage, MNBuilt 1948 · S/N 14-170 N5160LMikesell Bruce A · New Madison, OHBuilt 1967 · S/N 28-4445 N5160RTownley Wren Adam T · Orwell, VTS/N 17263377 N5160SJohnson Matthew N · Redgranite, WIBuilt 1970 · S/N 28-7105014 N5160TBeaver Enterprises Inc · Wilmington, DEBuilt 1981 · S/N R18201827 N5160XCulver Deborah M · Anchorage, AKBuilt 1969 · S/N 166 N5160ZWend Roger W · Charlotte, MIBuilt 1961 · S/N 22-8814 N51614Stillwater Flyers LLC · Columbus, MTBuilt 1981 · S/N 17274330 N51616Stardust Aviation LLC · Farmingdale, NYBuilt 1980 · S/N 17274331 N5161LGonzalez Ramiro Z · Homeland, CABuilt 1967 · S/N 28-4446 N5161MSamora Bobby · Corona, CAFirst renewal noticeBuilt 1978 · S/N M-2039 N5161PN5161p LLC · Upland, CABuilt 1958 · S/N 24-177 N5161SCapen Leasing LLC · Palm City, FLBuilt 1970 · S/N 28-7105015 N5161TStuart M Davis Inc · Rice, WABuilt 1967 · S/N 250 N5161XSlease Brian D · North Pole, AKS/N 167 N51627Warren David T · Mobile, ALS/N 18-8562 N5162FLosasso Michaela Marie · Scottsdale, AZBuilt 1979 · S/N 17273120 N5162LBlue Gecko LLC · Sheridan, WYBuilt 1967 · S/N 28-4447 N5162MCorcoran Thomas A · Braintree, MABuilt 1978 · S/N M-2040 N5162PHorton Melody A · Diamondhead, MSBuilt 1958 · S/N 24-178 N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379 N5162SStramer Douglas W · Hazelton, NDBuilt 1970 · S/N 28-7105016 N5162TAdvanced Insulation Enterprises LLC · Calhoun, LABuilt 1967 · S/N 253 N5162XMcmorries Kyle Patrick · Nacogdoches, TXBuilt 1969 · S/N 691 N51635Kovaleski Thomas J · Chugiak, AKBuilt 1974 · S/N 5025C N51637South Dakota State University · Brookings, SDS/N 172S9033 N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438 N5163HLsn Air LLC · Morrison, COBuilt 2001 · S/N 172S8933 N5163LBowyer Richard A · Ormond Beach, FLS/N 28-4448 N5163PReynolds David A · Blacksburg, VAS/N 24-179 N5163SValley Fliers Flying Club · Auburn, WABuilt 1970 · S/N 28-7105017

Back to AD 81-18-04 R2