Registered aircraft · 81,720

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.

N218JAWildwood Helicopter Co Inc · Wildwood, NJBuilt 1981 · S/N 15285307 N218JMAhlgrim Mark W · North East, PABuilt 1990 · S/N 218 N218KKSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496153 N218LBauer George W · Windermere, FLS/N 68 N218LDGriffin James L · Tulsa, OKBuilt 2005 · S/N 008 N218LKKowalski Leo J · Whitehall, PABuilt 2019 · S/N 25585 N218MAHospodar Robert P · Georgetown, PAS/N 2 N218MMN218mm LLC · Portland, ORBuilt 1964 · S/N 2825 N218MPSupair Ltd · Mooresboro, NCBuilt 2008 · S/N 352 N218PPSumrell James E III · Bumpass, VABuilt 1976 · S/N 172-67520 N218RARozo Jhon B · Orlando, FLBuilt 1975 · S/N 17265450 N218RBStewart Lawrence D · Council Bluffs, IABuilt 1990 · S/N 623 N218RJGauntlet Aerospace LLC · Henderson, NVBuilt 1982 · S/N 1 N218SRegistered aircraftBuilt 2018 · S/N 90187 N218TSullivan Ross A · Saint Helena, CABuilt 1953 · S/N 18-2332 N218TBJeffers Billy R · Southside, ALBuilt 1982 · S/N 218 N218TCCone Timothy E · Fresno, CABuilt 2007 · S/N TC 82071 N218TSAeronautica LLC · West Hollywood, CABuilt 1966 · S/N 28-3675 N218VGreen Gary E · Cotter, ARBuilt 2006 · S/N 45 N218WGWilliams Sydney E · Kendallville, INBuilt 1969 · S/N 28R-35345 N218WLN218wl LLC · Marshalltown, IABuilt 2004 · S/N 40.387 N218WSOrourke Brendan W · Stoughton, WIBuilt 1979 · S/N 28-8090094 N218ZMSkylink Xpress Inc · San Bernardino, CABuilt 1977 · S/N 15280011 N2190PN2190p LLC · Titusville, FLS/N 23-799 N2190TGonzales Rene V · Lampasas, TXBuilt 1971 · S/N 28-7205029 N2191EBel Air Aviation LLC · Chesaning, MIFirst renewal noticeBuilt 1978 · S/N 28-7990179 N2191JOefelein William A · Wasilla, AKBuilt 1960 · S/N 18-7185 N2191LAir Leasing Service Inc · Hillsborough, NJS/N 28R-7918031 N2191UJohnson Kenneth E · Mahtomedi, MNBuilt 1964 · S/N 402 N2191WNorton Daniel J · Osage City, KSBuilt 1974 · S/N MB-727 N21921Rosato Kevin Scott · Cullowhee, NCBuilt 1979 · S/N 61P-07147963345 N2192PSandoval Tax Cpas Inc · Bakersfield, CABuilt 2005 · S/N 18281668 N2192QAdams Kenny G · Phelan, CABuilt 1974 · S/N 177RG0592 N2192TMazza Frank · Bridgeton, NJBuilt 1971 · S/N 28-7205043 N2192WRegistered aircraftS/N 22-2605 N2193PDeem Adam C · Norton, OHBuilt 1990 · S/N 1795 N2193QGerber John T · Lumberton, NCBuilt 1974 · S/N 177RG0593 N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266 N2193WAzalea Utilities Inc · Summerville, SCBuilt 2005 · S/N 18281670 N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203 N2194LState Of Wisconsin · Madison, WIBuilt 2005 · S/N 18281672 N2194QMartin Dennis E · Oconto, WIBuilt 1974 · S/N 177RG0594 N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045 N21950Cousins Mark T · Portland, ORS/N 17264046 N21956Lake Elmo Flyers LLC · Vadnais Heights, MNBuilt 1974 · S/N 17264048 N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182 N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032 N2195MKorba Sean · San Jose, CABuilt 1979 · S/N 28-7911090 N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803 N2195QWatters Claytus James · Magnolia, TXBuilt 1974 · S/N 177RG0595

Back to AD 81-18-04 R2