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.

N5085SHall Thomas K · Beaufort, NCBuilt 1971 · S/N 28R-7135085 N5085VStumpf Douglas D · Aledo, TXBuilt 1977 · S/N VAC74-77 N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94 N5085XAzzalin Giorgio · Jacksonville, FLS/N 158 N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703 N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324 N5086SAero Air Inc · Salt Lake City, UTBuilt 1971 · S/N 28R-7135086 N5086XJacono Bruce L · Ramona, CABuilt 1969 · S/N 159 N5086ZRichards Curtis A · Troy, MOBuilt 1961 · S/N 22-8718 N50873Bastien Peter M · Leesburg, VABuilt 1979 · S/N JR-1 N5087JSession Jason E · Higden, ARS/N 17273698 N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958 N5087LGreen Airport Development Corp · Kemah, TXBuilt 1980 · S/N 15284253 N5087SKartchner Stanley J · Tucson, AZBuilt 1980 · S/N R18201502 N5087WMcgough Craig N · Lancaster, TXBuilt 1961 · S/N 28-96 N5087XRichardson Ethan Mack · Mount Pleasant, SCBuilt 1969 · S/N 160 N5087YHansen Dewayne E · Fairbanks, AKBuilt 1962 · S/N 18-7894 N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497 N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959 N5088LRichmor Aviation Inc · Hudson, NYBuilt 1980 · S/N 15284254 N5088MGeneral Aviation Partners LLC · Madison, ALBuilt 1967 · S/N 28-10928 N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94 N5088QMetro Aircraft Co · Bloomington, MNBuilt 2001 · S/N 172S8972 N5088RGlacier Equipment LLC · Wasilla, AKBuilt 1974 · S/N 17263326 N5088SSwaz Aviation LLC · Mesa, AZBuilt 1971 · S/N 28R-7135089 N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343 N5088XAmerican Aviation II LLC · Peyton, COS/N 659 N5088ZDavis Scott A · Bingham, NEBuilt 1961 · S/N 22-8722 N5089GFlywell Aviation LLC · Bowling Green, KYBuilt 1979 · S/N 17273538 N5089JWentzel Ron · Steamboat Springs, COBuilt 1979 · S/N 17273699 N5089PBroburg Gregory William · Minneapolis, MNBuilt 1981 · S/N 15284873 N5089RHigh Wing Air Services LLC · Merritt Island, FLBuilt 1974 · S/N 17263327 N5089STye Richard Ray · Silverado, CABuilt 1971 · S/N 28R-7130004 N5089XYarger Pete A · Hamilton, INBuilt 1969 · S/N 654 N5089YLewis Aaron J · Salado, TXS/N 27-2109 N508ADHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 3290 N508AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2020 · S/N 28020007 N508BVand Flyve Klub · Newfolden, MNS/N CC18-0015 N508BDIron Wings Aviation LLC · Ralph, MIBuilt 1961 · S/N 28-214 N508CSJoey Os LLC · Darlington, PABuilt 2006 · S/N 11044 N508CXAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2006 · S/N 11074 N508FGRidgeline Assets LLC · Wilmington, DEBuilt 2022 · S/N 172S12910 N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508 N508MARms Beach Sierra LLC · Brownsville, TXBuilt 1975 · S/N MC-318 N508NDCorsair Aviation LLC · Pacoima, CABuilt 2010 · S/N 172S11061 N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281 N508TBlackburn D S · Yukon, OKBuilt 1968 · S/N 611 N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869 N508VStahl Victor A · Houston, TXBuilt 2006 · S/N 71303 N508VKShuwayhat Khalid Numan Trustee · Phoenix, AZBuilt 2006 · S/N MK-0582

Back to AD 81-18-04 R2