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.

N8623EBeach Pilot LLC · Winchester, VABuilt 1976 · S/N 28-7690182 N8623WNeville Scott A · Phoenix, AZBuilt 1963 · S/N 28-10138 N8624W3l Executive Coach LLC · Duncan, OKBuilt 1963 · S/N 28-10139 N8625NJanicke Clayton R · Bird City, KSBuilt 1970 · S/N 32-7140018 N8626NCf Aviation LLC · Wellington, FLBuilt 1970 · S/N 32-7140019 N8626WBoies Ryan Nicholas · Auburn, MEBuilt 1963 · S/N 28-10141 N8627WNash Kim A · Billings, MTBuilt 1963 · S/N 28-10142 N8629NN8629n Inc · Ooltewah, TNBuilt 1971 · S/N 32-7140022 N8629WKowalewski Dennis R · Mesquite, NVBuilt 1963 · S/N 28-10144 N862JCHrs Equity Consulting LLC · Miami Beach, FLBuilt 2019 · S/N 2881281 N862PUTrustees Of Purdue University · West Lafayette, INS/N 2881335 N862TCAirmax Aviation LLC · Lake Worth, FLBuilt 1977 · S/N 28-7716290 N8630NLowe Alexander · Wauwatosa, WIBuilt 1971 · S/N 32-7140023 N8630WOswalt Todd A · Apache Junction, AZBuilt 1963 · S/N 28-10145 N8631NOwen Toy C · Anchorage, AKS/N 32-7140024 N8633EPompano Senior Squadron Flying Club Inc · Pompano Beach, FLS/N 28-7625145 N8634EFerguson Bryan K · Salem, VABuilt 1976 · S/N 28-7615144 N8634NWright David P Jr · Chandler, AZBuilt 1971 · S/N 32-7140027 N8634WMann Ian W · Camarillo, CABuilt 1963 · S/N 28-10149 N863PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843946 N863PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881477 N863SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881799 N8642WKruckeberg Lloyd E · Amarillo, TXBuilt 1963 · S/N 28-10159 N8643WJull Pamela · Bellingham, WABuilt 1963 · S/N 28-10150 N8644WMatos Noel · Newport Beach, CABuilt 1963 · S/N 28-10057 N8645ECichocki Matthew R · Oviedo, FLBuilt 1976 · S/N 28-7690183 N8647ESkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843374 N8647NVossberg Carl A · Umatilla, FLBuilt 1971 · S/N 28R-7135128 N8647WChase Dan · Reno, NVS/N 28-10163 N8649NManchester Thomas P · Wilmington, DEBuilt 1971 · S/N 28-7125460 N8649WHigh Desert Flyers LLC · New London, NCBuilt 1963 · S/N 28-10165 N864PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881498 N8650EGotta Fly LLC · Manitou Springs, COBuilt 1976 · S/N 28-7690184 N8650NAllen Flight Service LLC · Laredo, TXBuilt 1971 · S/N 28R-7135106 N8651CDoby Julian · Graham, NCBuilt 1976 · S/N 28R-7635170 N8651ESchoen Michael · Lakeville, MNBuilt 1976 · S/N 28R-7635193 N8652NDavis Rick J · Los Lunas, NMBuilt 1971 · S/N 32-7240002 N8652WCass Michael Norman · Moscow, IDBuilt 1963 · S/N 28-10170 N8653WZook James E · Holt, MIBuilt 1963 · S/N 28-10174 N8654WJordan Kenneth J · The Villages, FLBuilt 1963 · S/N 28-10175 N8655WGtj LLC · Johnston, IABuilt 1963 · S/N 28-10176 N8656NN8656n LLC · Weston, NEBuilt 1971 · S/N 32-7200001 N8658NOne Way Aviation LLC · Warner Robins, GAS/N 32-7240008 N8659EKuehn Ricky A · Mesa, AZBuilt 1976 · S/N 28-7625146 N8659WFlint Christopher · Tucson, AZS/N 28-10184 N865ACAri Ben Aviator Inc · Fort Pierce, FLS/N 2881386 N865GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881467 N865PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881490 N865WAYjb Operations LLC · Altoona, PABuilt 1978 · S/N 32R-7885134 N8660NRobbins Jode A · Cameron, WIFirst renewal noticeBuilt 1971 · S/N 32-7200002

Back to AD 87-08-08 R3