Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N80585Ck Leasing Services LLC · Wilmington, DEBuilt 1976 · S/N 17266660 N80587Malilay Jurrel Albino A · East Palo Alto, CABuilt 1981 · S/N 15285366 N8058BBreisch Frederick A Jr · Findlay, OHBuilt 1957 · S/N 29858 N8058MMaxfield Aviation LLC · Seattle, WABuilt 1976 · S/N 18264534 N8058USafer Jonathan · West Milford, NJBuilt 1976 · S/N 15077883 N80590Air Ward Inc · Novato, CABuilt 1976 · S/N 17266663 N80597Panker Patricia A · Lake Havasu City, AZS/N 17266666 N805AJMoyer Aviation Inc · Ulysses, KSS/N 20601769 N805NRState Of Minnesota · Grand Rapids, MNBuilt 1981 · S/N 18504197 N805SLCounty Of San Luis Obispo Sheriffs Office · San Luis Obispo, CABuilt 1982 · S/N 18268271 N80602Crass Harold L · Albuquerque, NMBuilt 1976 · S/N 17266668 N8060LOneonone Flight Training LLC · Hagerstown, MDS/N 17256260 N8060SGrinfeder Alex J · Little Rock, ARBuilt 1965 · S/N 15061660 N8060ZMason Michael · Anchorage, AKBuilt 1968 · S/N 18051992 N8061Gibson Isaac S · Saint John, INBuilt 1965 · S/N 15061669 N80612Wodishek Mark A · Honolulu, HIBuilt 1976 · S/N 17266670 N80616Aero Equities LLC · Ventura, CABuilt 1976 · S/N 17266671 N80619Level Flight Aviation LLC · Prior Lake, MNS/N 17266673 N8061BUrioste Zachary Ty Fred · Fort Collins, COBuilt 1957 · S/N 29861 N8061FMorales Jose · Mission, TXBuilt 1966 · S/N 15064161 N8061GMolstad Jerome M · La Crosse, KSBuilt 1971 · S/N 177RG0061 N8061LColeman Terrence C · Maryville, TNBuilt 1967 · S/N 17256261 N8061XSteck Phillip G · Smartsville, CAS/N 17248561 N8061ZCarter Kristopher W · Bellingham, WABuilt 1965 · S/N U206-0461 N80620Dkr Flyers LLC · Vandalia, MOBuilt 1976 · S/N 17266674 N80627Darke County Aircraft Rental Inc · New Madison, OHBuilt 1976 · S/N 17266676 N80628Goyne Gregory Ashley · Wrangell, AKS/N 17269062 N80629Registered aircraftBuilt 1976 · S/N 18503131 N8062BPalmer Felix E Jr · Murphy, NCBuilt 1957 · S/N 29862 N8062EAviation Specialized Services LLC · Lewisville, TXS/N 17272123 N8062FJackson Hugh W · Cordova, SCBuilt 1966 · S/N 15064162 N8062GKelly Michael · Kaneohe, HIBuilt 1971 · S/N 177RG0062 N8062SSturm Steve G Trustee · Springdale, ARS/N 15061662 N8062XHerring Fred A · Walnut Ridge, ARBuilt 1961 · S/N 17248562 N80633Rockalong Holdings LLC · Stanton, TXBuilt 1976 · S/N 18503132 N80635Clements Calvin · Palmyra, PABuilt 1976 · S/N 17266683 N80636Walls George H · Matthews, NCBuilt 1976 · S/N 17266684 N8063ACarleton Jeffrey S · Palmer, AKBuilt 1952 · S/N 20915 N8063EHale Mitchell D · Chugiak, AKS/N U2060926 N80641Missionary Flight Training Inc · Fort Pierce, FLBuilt 1976 · S/N 17266686 N80643Santa Barbaara Flying Club · Goleta, CABuilt 1976 · S/N 17266687 N8064BCarrison Harold F · Pleasanton, CABuilt 1957 · S/N 29864 N8064LMccormick Michael P · Durham, NCBuilt 1967 · S/N 17256264 N8064TThomas Raymond · Deer Park, WAS/N 56764 N80657Shelburne Airport Inc · Shelburne, VTBuilt 1976 · S/N 17266693 N8065LDream Big Aviation LLC · Mount Juliet, TNS/N 17256265 N8065MStoll Albert G · Healdsburg, CABuilt 1976 · S/N 18264536 N8065TDefalco James B · Simi Valley, CABuilt 1960 · S/N 56765 N8065XCollege Of Missionary Aviation Inc · Keystone Heights, FLBuilt 1961 · S/N 17248565 N8065ZZulu Forty One LLC · Anchorage, AKS/N U206-0465

Back to AD 87-20-03 R2