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.

N9111GMaryland State Police · Baltimore, MDBuilt 1986 · S/N 3206003 N9111KWdiaz Design Inc · Sunny Isles Beach, FLBuilt 1976 · S/N 28R-7635221 N9112JCmm Aviation LLC · Dover, FLBuilt 1966 · S/N 28-3154 N9112WCherokee N9112w LLC · Boise, IDBuilt 1966 · S/N 28-10723 N9112ZWalters Darren · Overland Park, KSBuilt 1986 · S/N 2890017 N9113KBaja Airventures Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680189 N9113WFlying Magic LLC · Post Falls, IDBuilt 1966 · S/N 28-10724 N9114DMacair Aviation LLC · Xenia, OHBuilt 1987 · S/N 2890032 N9114JRouss Charles F · Martinsburg, WVBuilt 1966 · S/N 28-3157 N9115QSoto Daniel-Rey · Smiths Station, ALBuilt 1987 · S/N 2890033 N9116JPolcyn Matthew D · Millersburg, OHBuilt 1966 · S/N 28-3160 N9116WKoury Michael Jacob · Fort Mohave, AZBuilt 1966 · S/N 28-10728 N9116ZIron 17 Investments LLC · Mount Pleasant, TXBuilt 1987 · S/N 2811015 N9117WLittle Wing Aero LLC · East Longmeadow, MABuilt 1966 · S/N 28-10729 N9118SSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 2816010 N9118WHalford Robert · Troy, TXBuilt 1966 · S/N 28-10730 N9118ZFlying Mermaid LLC · Aiea, HIBuilt 1986 · S/N 2890022 N9119JAlex Aircraft LLC · New Albion, NYBuilt 1966 · S/N 28-3166 N9119WBas Part Sales LLC · Greeley, COS/N 28-10732 N911DWOcmulgee Outdoors Inc · Hazlehurst, GABuilt 2000 · S/N 3257133 N911HPBowling Timothy N · Willis, TXBuilt 1974 · S/N 28-7505077 N911MHSierra Charlie LLC · Greenville, SCBuilt 1976 · S/N 32R-7680408 N911PSBittner Gregory L · Greensburg, PAS/N 28R-7435279 N911SAIntensive Medical Inc · Clermont, FLBuilt 1976 · S/N 32-7640059 N911UAMiloud Chadd K · Fort Worth, TXS/N 28-20262 N9120JShastaero Inc · Redding, CABuilt 1966 · S/N 28-3167 N9121JMamolou Bill A · Newport Richey, FLBuilt 1966 · S/N 28-3168 N9121WAbrams Adrian L · Palmer, AKS/N 28-10737 N9123DEngineers Flying Club · Bethany, OKBuilt 1987 · S/N 3206011 N9123JQualitair LLC Trustee · MichelstadtBuilt 1966 · S/N 28-3172 N9123KCooley Tommy Joe · Waynesboro, MSBuilt 1976 · S/N 28-7615174 N9123PEye Sea Aviation LLC · Wilmington, NCBuilt 1987 · S/N 2811016 N9123WElse John J · Toledo, IABuilt 1966 · S/N 28-10739 N9123XHeavenly Realms Aviation LLC · Grand Junction, COBuilt 1987 · S/N 3229003 N9125JOlson Scott S · Mission Hill, SDBuilt 1966 · S/N 28-3174 N9126SMartell Edward G · Fountain Valley, CAS/N 3206014 N9126WBlack Dean A · Somers, IABuilt 1966 · S/N 28-10743 N9127JMettler Bryan Fred · Dansville, NYBuilt 1966 · S/N 28-3176 N9127NKohler David W · Portland, INBuilt 1993 · S/N 2890175 N9127WDeshayes Eric Thorson · Gypsum, COBuilt 1966 · S/N 28-10744 N9128JWyoplane LLC · Rock Springs, WYS/N 28-3178 N9128WBoiler Express LLC · Gouldsboro, PABuilt 1987 · S/N 3213005 N9128ZRpd Aviation LLC · Saint Joseph, MNBuilt 1987 · S/N 3213008 N9129JLindsey Patrick E · Gulf Breeze, FLS/N 28-3179 N912ARMicam Development LLC · Weatherford, TXBuilt 2007 · S/N 3257445 N912BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881854 N912DMMasser Farming Inc · Sacramento, PABuilt 2002 · S/N 3257293 N912JDaucher Kelsey K · Oak Harbor, WABuilt 1978 · S/N 28-7916064 N912PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843302 N912WPotter Billy Lee · Temple, TXBuilt 1967 · S/N 28R-30256

Back to AD 87-08-08 R3