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.

N511STTilford Stephen J · The Villages, FLBuilt 2017 · S/N 72341 N512Birdwell Larry · Cedar Hill, TXBuilt 2000 · S/N M-II-1388 N5120GGoering Vincent R · Hephzibah, GABuilt 1968 · S/N 28-4937 N5120HTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15284063 N5120LClifford Scott P · Wallkill, NYBuilt 1967 · S/N 28-4403 N5120SIntentus Aviation LLC · Sunset, TXBuilt 1971 · S/N 28-7105171 N5120TPrince Ronald D · Beach City, OHBuilt 1966 · S/N 479 N5120WSeasons Of Life Publications LLC · Greenville, SCBuilt 1961 · S/N 28-145 N51213Shelley Aaron J · Corbin, KYBuilt 1974 · S/N 17264227 N5121GWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 28-5005 N5121HGilsdorf Jason M · Henning, MNBuilt 1947 · S/N 14-127 N5121KTebbe Francis L · Maryville, ILBuilt 2007 · S/N 1308 N5121QClift William R II · Princeton, KYBuilt 1973 · S/N 17261756 N5121SSandmann Ross · Plano, TXBuilt 1971 · S/N 28-7105175 N5121TBourn Rachael · Magee, MSBuilt 1966 · S/N 307 N5121WCarroll Thomas F · Independence, MOBuilt 1961 · S/N 28-146 N5121ZDahlberg Thomas K · Belvidere, ILBuilt 1961 · S/N 22-8762 N51221Provost Kevin H · North Swanzey, NHS/N 17264228 N51222Mbk Leasing And Consulting LLC · Lakeland, FLBuilt 1980 · S/N 17274283 N5122BTutt Bryan D · Louisville, KYBuilt 1979 · S/N 15283759 N5122LJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1967 · S/N 28-4405 N5122PBluesky Equipment LLC · Panama City, FLBuilt 1981 · S/N 15284882 N5122R1st Clev-Mar LLC · Lakeview, ARBuilt 1974 · S/N 17263340 N5122SKudla Frank R · Bean Station, TNBuilt 1971 · S/N 28-7105172 N5122UChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 172S10911 N5122WSale Reported · Cape Elizabeth, MESale reportedBuilt 1961 · S/N 28-148 N5122ZDunn Kohlten Davis · Rexburg, IDBuilt 1961 · S/N 22-8763 N51236Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274286 N51238Flying G Aviation Inc · Drayton, NDBuilt 1980 · S/N 17274287 N5123EMiller Kenneth Allen · Riverhead, NYBuilt 1978 · S/N 17271722 N5123JCircle W Flying Club Inc · Creighton, PABuilt 1979 · S/N 17273709 N5123RGiving Wings Aviation LLC · Traverse City, MIBuilt 1974 · S/N 17263341 N5123SChristopher Craig · Colbert, WABuilt 1993 · S/N 001 N5123TSlaughter Patricia C · Saranac, MIBuilt 1966 · S/N 122 N5123VAustin Jeffrey L Trustee · Salem, ORBuilt 1961 · S/N SP-19 N5123WVaughn Jesse L · Poplar Bluff, MOBuilt 1961 · S/N 28-149 N51240Young Roger P · Sewickley, PABuilt 1980 · S/N 17274288 N51249Flying Turkey LLC · Flower Mound, TXBuilt 1974 · S/N 17264230 N5124BHillsboro Aero Academy Llcc · Hillsboro, ORBuilt 1979 · S/N 15283761 N5124EHarris Russell Farrell · Chino Valley, AZBuilt 1978 · S/N 17271723 N5124HFowler Thomas J · Keller, TXBuilt 1948 · S/N 14-130 N5124JAbove And Beyond Aviation LLC · Austin, TXS/N 17273710 N5124LCrisp Phil · Greencastle, PABuilt 1967 · S/N 28-4407 N5124MWerner James J · Cave Creek, AZBuilt 1978 · S/N MC-576 N5124RGarrison Randy L · Queen City, TXBuilt 1974 · S/N 17263342 N5124SCalvert David · Livermore, CABuilt 1971 · S/N 28R-7135154 N5124TAnderson Bryan C · Arlington, TNBuilt 1967 · S/N 23 N5124VAuiler Casey M · San Diego, CABuilt 1961 · S/N SP-20 N5124ZCummings Christopher K · Chalfont, PABuilt 1961 · S/N 22-8765 N51254Christiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274291

Back to AD 81-18-04 R2