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.

N6105WBlackwell Mario S · Lathrop, CABuilt 1964 · S/N 28-20119 N6109JKane Michael Vincent II · Virginia Beach, VAS/N 28-7625219 N6109WCity Of Westfield · Westfield, MABuilt 1964 · S/N 28-20123 N610CCClub Cherokee Inc · Crystal, MNBuilt 1976 · S/N 28-7615140 N610FAStratus Rr LLC · New Castle, DEBuilt 2023 · S/N 28020110 N610FLRoberts John R Jr · Homestead, FLS/N 28-7125488 N610LBWinters Jesse · New Braunfels, TXBuilt 1976 · S/N 32R-7680304 N610MAThomas Michael J · Malabar, FLBuilt 1966 · S/N 32-40105 N610NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881136 N610SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881600 N610SHSeto Christopher · Seattle, WABuilt 1972 · S/N 28-7305139 N610UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020166 N6110WZimmerman David A · Memphis, TNBuilt 1964 · S/N 28-20125 N6112JColeman Timothy Lynn · Port Charlotte, FLBuilt 1976 · S/N 28-7690342 N6112WRoberts Jackie P · Bangs, TXBuilt 1964 · S/N 28-20127 N6113JOracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7690343 N6113WMurray Brian C · Jonesboro, ARS/N 28-20128 N6114WGottschalk William R · Fort Atkinson, WIBuilt 1964 · S/N 28-20129 N6116JGlobal Technical Services Inc · Fort Worth, TXBuilt 1976 · S/N 28R-7635299 N6116WKlyder Thomas A · Inverness, FLS/N 28-20131 N6117WRoesler Robert D · Gordonsville, VAS/N 28-20132 N6118WPiekielek John L · Punxsutawney, PABuilt 1964 · S/N 28-20133 N611AJLancaster Aaron · Vacaville, CAS/N 28-7911172 N611CMMasters Charles O · Garden Ridge, TXBuilt 1978 · S/N 28R-7837210 N611FLZipp Nicole E · Raleigh, NCBuilt 1971 · S/N 28-7125489 N611FTCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841223 N611JPAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1978 · S/N 287916111 N611SCFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 2881601 N611VMCavender Jake Scott · Jacksonville, FLBuilt 1971 · S/N 28-7125344 N611VWAlley Mark Z · Cedar City, UTS/N 28-20130 N611WLVincent Brett D · Fayetteville, GABuilt 1978 · S/N 32R-7885212 N6121HRethink Creative Group LLC · Fort Worth, TXBuilt 1977 · S/N 28-7816225 N6121WRadius Aviation LLC · Fort Rucker, ALBuilt 1964 · S/N 28-20137 N6122JVatm Sky Investments LLC · Thomson, GABuilt 1976 · S/N 28-7615305 N6122WN6122w LLC · Tillamook, ORS/N 28-20138 N6123JBullard Dennis E · Fort Myers, FLBuilt 1976 · S/N 28-7690345 N6123QAirflair Inc · Maurice, IABuilt 1976 · S/N 28-7790065 N6124JCrews Aaron Gregory · Boone, IABuilt 1976 · S/N 28-7690346 N6124MDiscovery Air LLC · Austin, TXBuilt 2000 · S/N 3257143 N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255 N6126WMatthews James C · Gilbert, SCBuilt 1964 · S/N 28-20142 N6127HBless Howard P · Pennsburg, PAFirst renewal noticeBuilt 1977 · S/N 28-7816226 N6127WLa Aviation Ltd · Wilmington, DES/N 28-20143 N6129HHouk Air LLC · Waverly, OHBuilt 1977 · S/N 28-7890209 N6129JBlue Skies Aircraft LLC · Kalispell, MTBuilt 1976 · S/N 28-7625221 N612FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816197 N612GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881195 N612JSWings Of Eagle LLC · Leo, INBuilt 1970 · S/N 32-40935 N612LCGoodman Lawrence A · Granbury, TXBuilt 1969 · S/N 28-26033 N612PAJenkins Phillip R Jr · Fuquay Varina, NCBuilt 1977 · S/N 28-7790518

Back to AD 87-08-08 R3