Skip to content

Registered aircraft · 22,413

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N2319TJensen Betty K · Ithaca, NYBuilt 1971 · S/N 28-7105212 N231MAGolden Age N231ma LLC · Norwalk, IABuilt 2022 · S/N 2881564 N2321MPartridge John M · Danville, CABuilt 1977 · S/N 28-7816278 N2321THobson Joseph C · Beverly Hills, FLBuilt 1971 · S/N 28R-7130009 N2323TTweeddale Thomas A · Denton, TXBuilt 1971 · S/N 28-7125606 N2325TFlorida State College At Jacksonville · Jacksonville, FLBuilt 1971 · S/N 28R-7135201 N2326URodger Roberts Inc · Winchester, OHBuilt 1979 · S/N 28-7911296 N2326VEby Thomas R · Winter Springs, FLBuilt 1985 · S/N 28-8590067 N2327TSale Reported · Hampton, GASale reportedBuilt 1971 · S/N 28R-7135216 N2328TElite Flight LLC · Lordstown, OHBuilt 1971 · S/N 28R-7135217 N2329TColvin Timmy R · Valentine, NEBuilt 1971 · S/N 28-7110028 N232CASawdust Aviation Inc · Bellefonte, PABuilt 1976 · S/N 32-7740026 N232DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010032 N232MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881983 N232SPTucker Adam C · Clermont, FLBuilt 1978 · S/N 28-7990205 N232TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881550 N232TSTwo Tango Sierra LLC · Edmond, OKBuilt 1982 · S/N 32R-8229041 N232WFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1966 · S/N 28-21971 N2330TSteele Jackie L · London, KYS/N 28R-7130010 N2331MSmith Ctr Kite Club Inc · Smith Center, KSBuilt 1977 · S/N 28-7890247 N2333RSightler Marshal · Taylors, SCBuilt 1969 · S/N 28-5491 N2333TNottingham Jeffrey A · Locust Grove, GABuilt 1971 · S/N 28R-7135204 N2334MSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 28R-7837083 N2334TGogoplex LLC · Wilmington, DEBuilt 1971 · S/N 28-7125637 N2336RPerera Nandana L · Logan, OHBuilt 1969 · S/N 28-5494 N2336TN2336t Airplane Partnership LLC · Wilmington, DEBuilt 1971 · S/N 28R-7135209 N2337UOne Niner Right LLC · Berkeley, CABuilt 1979 · S/N 28-7911300 N2339TK E F Enterprises Inc · Plymouth, MABuilt 1971 · S/N 28R-7135227 N2339VBradford Sarah Elisabeth · Norman, OKBuilt 1985 · S/N 28-8511015 N233CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881389 N233SPBuchwald Greg W · Grapevine, TXBuilt 1961 · S/N 28-223 N2340TGrillo Donald · Green Cove Springs, FLBuilt 1971 · S/N 28R-7135228 N2341TSky King Aviation LLC · Kearney, MOBuilt 1971 · S/N 28-7225048 N2343RSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1969 · S/N 28-5495 N2343TManire Christine D · Ruidoso, NMBuilt 1971 · S/N 28-7225049 N2343ULanning Dwight V · Thaxton, VAS/N 28-7911301 N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050 N234AJMullins Land Co Inc · Aiken, SCBuilt 1995 · S/N 3246008 N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369 N234DLAngel Wings LLC · Waxhaw, NCFirst renewal noticeBuilt 1983 · S/N 32R-8329029 N234JCL&L Air LLC · Cave Creek, AZBuilt 1976 · S/N 28-7715093 N234JFInternational Air Services Inc Trustee · Carson City, NVS/N 32R-7887265 N234KMMurray Edward L · Hoover, ALS/N 28-7990043 N234PAJuliet Two LLC · Ocean Ridge, FLBuilt 1978 · S/N 28-7816677 N234TAGilk Timothy H Trustee · Redwood Falls, MNBuilt 1978 · S/N 32-7840119 N2350MCampbell J Bryce · Stillwater, OKBuilt 1977 · S/N 28R-7803125 N2350UMersino Peter J · Fresno, CABuilt 1979 · S/N 28-7911302 N2351BRegistered aircraftBuilt 1973 · S/N 28-7325535 N2351MGot My Six LLC · Lewes, DES/N 32-7840047 N23585Smile By Air LLC · Columbus, OHBuilt 1975 · S/N 32R-7680007

Back to AD 87-08-08 R3