Skip to content

Registered aircraft · 72,010

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N56714Richman Martin S Trustee · Leawood, KSBuilt 1973 · S/N 28-7425024 N56717Hp Flight Service LLC · San Antonio, TXBuilt 1973 · S/N 28-7405028 N5671GMontana Wingnuts LLC · Kalispell, MTBuilt 1987 · S/N 7479C N5671SMusketeer Aviation Inc · Potterville, MIBuilt 1966 · S/N MB-110 N5671YShore Gerry · Inez, TXBuilt 1965 · S/N 27-2785 N5671ZQualls William C · Wellsville, KSBuilt 1962 · S/N 22-9495 N56720Precision Flight Training Inc · Newberg, ORBuilt 1973 · S/N 28R-7435034 N56723Sewell David J · Largo, FLBuilt 1973 · S/N 28-7425025 N56724Marianas Air Transfer Inc · Tinian, MPBuilt 1973 · S/N 28-7425026 N56728Morris Air LLC · Tillar, ARBuilt 1973 · S/N 32-7440021 N5672SHogan Jacob A · Canon City, COBuilt 1966 · S/N MA-82 N5672UWatson Phillip J · Jackson, TNBuilt 1969 · S/N 28-26469 N56734Hales Michael G · Farwell, MIBuilt 1973 · S/N 28-7425028 N56735Kilo Mike Aviation LLC · Hilliard, OHBuilt 1973 · S/N 28-7415008 N56736N56736 LLC · Fort Smith, ARBuilt 1973 · S/N 28-7405029 N5673QBrown Maxwell · Palm Springs, CABuilt 1965 · S/N 3035 N56748Cutler Matthew · Santa Clarita, CAS/N 28-7425029 N5674BCapehart Barbara · Springfield, ORS/N 408 N5674KCmt Properties LLC · Laurel, MSS/N TD-586 N5674PNeely Antwuan T · Savoy, ILBuilt 1959 · S/N 24-746 N5674QPac Hollow Flyers LLC · Omaha, NEBuilt 1965 · S/N 3105 N5674WJimenez Marcos A · Little Ferry, NJBuilt 1962 · S/N 28-868 N56750Williams Nicholas E K · Stacy, MNFirst renewal noticeBuilt 1973 · S/N 28-7425030 N56751Torroija Matias · Miami, FLBuilt 1973 · S/N 28-7415009 N56753Gwartney Bobby L Jr · Hammon, OKBuilt 1973 · S/N 28-7410029 N56755Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 34-7450029 N56756Morley Thomas O · Riverside, CAS/N 28-7425031 N5675PLandolt Gregg E · Moreno Valley, CAFirst renewal noticeBuilt 1959 · S/N 24-747 N5675QZeigler Matthew James · Fairfax Station, VABuilt 1965 · S/N 3036 N5675WAmmons Benjamin W Jr · Jacksonville, FLBuilt 1962 · S/N 28-898 N56765Morgan Diskin G III · Douglas, GABuilt 1973 · S/N 28-7410030 N56766Elliott Scott · Holmes, NYBuilt 1973 · S/N 32-7400008 N5676UMg Aviation · Oshkosh, WIBuilt 1969 · S/N 28-26473 N5676VDave Simpson Aviation Inc · Escondido, CABuilt 1977 · S/N 28-7790494 N5676XArmstrong Kyle John · Eugene, ORBuilt 1973 · S/N 28R-7435039 N56771Haight Robert A · East Haven, CTBuilt 1973 · S/N 28-7425032 N56777Jac Aero LLC · Springfield, ORBuilt 1973 · S/N 28-7415011 N5677PMourouzis Jack · Indianapolis, INBuilt 1959 · S/N 24-749 N5677QDeramus Doris L Executor · El Paso, TXS/N 3037 N5677UGolden Age Aviation LLC · Naperville, ILBuilt 1969 · S/N 28-26474 N5677VAnnies Aviation LLC · Bloomington, INBuilt 1977 · S/N 32R-7780359 N5677WLangel Brandon · Saint Charles, MOS/N 28-909 N5678Hutter Peter S · Aspen, COBuilt 1969 · S/N 60-0017 N56780Stewart Donald Kent · Denver, NCBuilt 1973 · S/N 28R-7435041 N56782Avie Ation LLC · Suwanee, GABuilt 1973 · S/N 34-7450031 N56783Dennerline Rhett R · Northfield, ILBuilt 1973 · S/N 28-7425035 N56786Janda Robert J · Grafton, OHBuilt 1973 · S/N 28-7415012 N56788Osgood Aaron · Glen Mills, PABuilt 1973 · S/N 28-7405031 N5678NRedwood Area Flyers LLC · Springfield, MNBuilt 1966 · S/N 0292 N5678PWhite John O · Camarillo, CABuilt 1959 · S/N 24-750

Back to AD 87-10-06 R1