Skip to content

Registered aircraft · 22,416

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.

N8769WDublin Aviation Corp · Columbus, OHRevoked, canceledBuilt 1964 · S/N 28-10310 N876EEEwing Robert A · Cedar Grove, NJBuilt 1971 · S/N 32-7100023 N876SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881745 N8771CSummit Aviation LLC · Spokane, WABuilt 1976 · S/N 28-7690163 N8771WRegistration Pending · Elkhorn, WIRegistration pendingBuilt 1964 · S/N 28-10313 N8773CScott Ansell E · San Diego, CAS/N 28-7690164 N8773NBeen Flyin LLC · Colchester, CTBuilt 1969 · S/N 28-25597 N8773WDurrence Glenn W · Glennville, GABuilt 1964 · S/N 28-10315 N8774WMeadows Dan R · Douglasville, GABuilt 1964 · S/N 28-10317 N8775NPerez Jeremiah · Fort Worth, TXBuilt 1969 · S/N 28-25599 N8777NDaniel Adam Christopher · Sanford, NCBuilt 1969 · S/N 28-25601 N8777WHendi Aviation LLC · New Castle, COBuilt 1964 · S/N 28-10321 N8778WBeery Milo A · Clarinda, IABuilt 1964 · S/N 28-10322 N8779CForever Fly LLC · Margate, FLBuilt 1976 · S/N 32R-7680138 N8779NNorth Little Rock Air Inc · North Little Rock, ARBuilt 1969 · S/N 28-25604 N8779WSpringer Chase William · Wasilla, AKBuilt 1964 · S/N 28-10323 N877DAWest Prairie Aircraft LLC · Weiner, ARBuilt 1969 · S/N 28-25877 N877DERon Cybulski Farms Inc · Caro, MIBuilt 2003 · S/N 3232009 N877DSEvans Ashley E · Elizabeth, COBuilt 1967 · S/N 32-40185 N877GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881469 N877HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844132 N877MAMason Rory L · Auburn, NEBuilt 1966 · S/N 28-3674 N877MDMd Max LLC · Dover, DEBuilt 2023 · S/N 2881662 N877RDDuste Richard A · Auburn, CAS/N 28R-7703360 N877SMWilson Michael J · Monterey, CABuilt 1967 · S/N 28-10969 N8781WLandreth David Ctrustee · Burson, CABuilt 1964 · S/N 28-10326 N8782WOrville Jeffrey Eich Jr · Omaha, NEBuilt 1964 · S/N 28-10327 N8783NGustafson Randolph W · Wisconsin Rapids, WIBuilt 1969 · S/N 28-25616 N8784NBates James L · Reisterstown, MDBuilt 1969 · S/N 28-25621 N8785FBeving Charles J · Garden City, SDBuilt 1976 · S/N 32R-7780116 N8785N85n Corp · Oak Hill, VABuilt 1969 · S/N 28-25622 N8786C8786c LLC · Cleburne, TXBuilt 1976 · S/N 28-7615129 N8786ELuv 2 Fly Ada LLC · Ada, OKBuilt 1976 · S/N 28-7615162 N8786NSorenson Kyle F · Deaver, WYBuilt 1969 · S/N 28-25772 N8786WPhoenix Eengineering LLC · Valley Center, CABuilt 1964 · S/N 28-10333 N8787CBrolan Aviation LLC · Kansas City, MOBuilt 1976 · S/N 28-7690165 N8787EMyers Danny A · Saint Charles, MOBuilt 1976 · S/N 28-7615163 N8787FLibby Nicholas J · Olympia, WABuilt 1976 · S/N 28-7715289 N8788CSaflight Pilot Training Inc · Manchester, NHS/N 28R-7635182 N8788ECoastal Fliers Inc · El Cajon, CABuilt 1976 · S/N 28-7690204 N8788WMacken Jason P · Lancaster, NYBuilt 1964 · S/N 28-10335 N878BTBlue Paradise Aviation LLC · Clive, IABuilt 2005 · S/N 3257402 N878DA92nd West Aviation Inc · Lonoke, ARS/N 28-7125620 N878DRFive Star Aviation LLC · Greer, SCS/N 32-46055 N878MJJackson Air LLC · Paragould, ARBuilt 1976 · S/N 32-7640078 N878WSWallace State Community College · Hanceville, ALBuilt 2021 · S/N 28020033 N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214 N8791EKl&Z Farms LLC · Littleton, NCBuilt 1976 · S/N 32-7600012 N8791NVetter Daniel W · Dayton, NVBuilt 1969 · S/N 28-25631 N8791WRegistration Pending · Johns Island, SCRegistration pendingBuilt 1964 · S/N 28-10339

Back to AD 87-08-08 R3