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.

N6160JKirby Alan F · Imperial, MOBuilt 1976 · S/N 28-7615317 N6160WSteinsvik Magne · Seattle, WABuilt 1964 · S/N 28-20056 N6161HCouture Michael E · Conway, NHS/N 28R-7803091 N6161VWorkman Lonnie H · Farmington, ARBuilt 1964 · S/N 28-20161 N6161WCarlson Darrin E · Clay Center, KSBuilt 1964 · S/N 28-20179 N6162WEvans Stephen M · Vashon, WABuilt 1964 · S/N 28-20180 N6163HSodolak Craig A · Magnolia, TXBuilt 1977 · S/N 28R-7803092 N6163WLang Michael R · Cedar Key, FLBuilt 1964 · S/N 28-20181 N6164JSchumar James F · Grand Rapids, MIBuilt 1976 · S/N 28R-7635315 N6164WSmith Steve W · Elizabethtown, KYBuilt 1964 · S/N 28-20182 N6165WSommers Wesley A · Kiana, AKBuilt 1964 · S/N 28-20183 N6166HMccolley Gregory · Glendale, AZBuilt 1977 · S/N 28R-7803093 N6166JBorder Steven C · Wharton, TXBuilt 1976 · S/N 28-7615318 N6168HWayne Air LLC · Collinwood, TNBuilt 1977 · S/N 32R-7880046 N6168WSchwenning Donald R · Upper Sundusky, OHBuilt 1964 · S/N 28-20186 N616ACN616ac LLC · Westfield, MABuilt 2021 · S/N 28020038 N616ADArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843736 N616ARCenturion Flyers LLC · Spokane, WABuilt 2006 · S/N 3257423 N616AWAtd Pilot Training Lllc · Kansas City, MOBuilt 1976 · S/N 28-7790171 N616FLFlight Gear Aviation LLC · Pickerington, OHBuilt 1971 · S/N 28-7125498 N616HTWright S A Trustee · Cave Creek, AZBuilt 1993 · S/N 2811043 N616JPWb Painting Contractors LLC · Greenville, MSBuilt 1967 · S/N 32-40420 N616PCPork Chop Aviation II LLC · Hilliard, OHBuilt 2023 · S/N 28020117 N616VTNamendorf Michael · New Hyde Park, NYBuilt 1979 · S/N 28-7916500 N6170JSeeler John A · Bristol, NHBuilt 1976 · S/N 28R-7635316 N6171HTyler Cherokee 235 LLC · Lindale, TXBuilt 1977 · S/N 32R-7880047 N6173JMinor Michael W · Summerland Key, FLS/N 32R-7680324 N6173WDiaz Jose O · Ramey, PRBuilt 1964 · S/N 28-20190 N6174JAloms Enterprises LLC · Marietta, GABuilt 1976 · S/N 32R-7680325 N6176JWertz Joseph S Jr · Shoemakersville, PABuilt 1976 · S/N 28-76-15321 N6179JSanders Jeffrey A · Aurora, COBuilt 1976 · S/N 32R-7680326 N617CMGravatt Eric Kenneth · Ammon, IDBuilt 1967 · S/N 28-10899 N617ECHungerford Brett · Cincinnati, OHBuilt 1975 · S/N 32R-7680096 N617ETBunck Richard DBA · Apple Valley, CABuilt 1967 · S/N 32-40205 N617FLHarris Nancy B · Christiansburg, VABuilt 1971 · S/N 28-7125502 N617JAYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 28020265 N6182WBarrette Jason W · Mandeville, LAS/N 28-20205 N6183WMartin Neal O · Reno, NVS/N 28-20207 N6184JInverted Holdings LLC · Newnan, GABuilt 1976 · S/N 28-7615324 N6185HSargent Patrick S · Bicknell, INBuilt 1977 · S/N 28-7890215 N6185JYankee Pilots Inc · Haverhill, MABuilt 1976 · S/N 28-7615325 N6186JRegistration Pending · Sebastian, FLRegistration pendingBuilt 1976 · S/N 28-7615326 N6186WWerren Carroll E · Concord, NHFirst renewal noticeBuilt 1964 · S/N 28-20210 N6187WAerospace Trust Management LLC Trustee · Wilmington, DES/N 28-20213 N6188JRaveesh Cn · Gladstone, MIBuilt 1976 · S/N 28-7690367 N618EMMoffitt Michael E · Kent, IABuilt 1971 · S/N 28-7205009 N618FLDexter Development LLC · Kingfield, MEBuilt 1971 · S/N 28-7125503 N618FTFlorida Institute Of Technology · Melbourne, FLBuilt 1985 · S/N 28-8516048 N618NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881137 N6190JMiller James A · Fairbanks, AKBuilt 1976 · S/N 32R-7680329

Back to AD 87-08-08 R3