Skip to content

Registered aircraft · 54,017

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.

N3609SSchuerch Vincent M · Wasilla, AKBuilt 1963 · S/N 17250809 N360ACAlpha Charlie LLC · Post Falls, IDBuilt 1975 · S/N 18263631 N360DCGolike Timothy R · Anchorage, AKS/N 185-02173 N360DLTorgerson Management Inc · Turtle Lake, WIS/N U20606033 N360JBSouthpark Partnership Ltd · Cullman, ALBuilt 1975 · S/N 18264476 N360MWMission Wings International Inc · Salem, OHS/N P206-0572 N360RJOliver Paul D · Bozeman, MTBuilt 1964 · S/N 206-0225 N3610EOrange County Flyers Inc · Mission Viejo, CAS/N 17271607 N3611CNicoll Steve · Bozeman, MTBuilt 1957 · S/N 31109 N3611JShannon James P · Vandergrift, PABuilt 1966 · S/N 15064911 N3611LVick Garland L · Benton, ARBuilt 1965 · S/N 17253780 N3611SCombs Charles M · Mesa, AZS/N 17250811 N3612CLipka Will · Center Point, TXBuilt 1954 · S/N 31110 N3612LClean Waste Solutions LLC · Indianapolis, INBuilt 1965 · S/N 17253781 N3613CSchneiderhan Edward F · Laurium, MIS/N 31111 N3613JBatista Brasil Vagner · Orlando, FLBuilt 1966 · S/N 15064913 N3613SMccomb Charles D · Cypress, TXBuilt 1963 · S/N 17250813 N3613UN3613u LLC · Lakeland, FLBuilt 1963 · S/N 18255013 N3614JSikveland Beau D · Circle, MTBuilt 1966 · S/N 15064914 N3614LHarris Danny R · Winnsboro, TXBuilt 1965 · S/N 17253783 N3614UT Yowonske Enterprises LLC · Rostraver Township, PAS/N 18255014 N3614YEmission -Air Inc · Lexington, NCBuilt 1962 · S/N 21058114 N3615CMarkwardt Jacquelyn K · Santa Cruz, CABuilt 1954 · S/N 31113 N3615LEynon Thomas Elliott · North Royalton, OHS/N 17253784 N3615SBlacqjacq Aviation Co · Wilmington, DEBuilt 1963 · S/N 17250815 N3616JB&R Aircraft LLC · Wadsworth, OHBuilt 1966 · S/N 15064916 N3616LSoflair Aviation Solutions LLC · Miami, FLS/N 17253785 N3616SArtisan Outreach LLC · Dunnellon, FLBuilt 1964 · S/N 17250816 N3616UHatch Koay A · Gilbert, AZBuilt 1963 · S/N 18255016 N3616YAnderson Dana R · Redding, CABuilt 1962 · S/N 21058116 N3617JShowalter Steven L · Goshen, INBuilt 1966 · S/N 15064917 N3617YSchindele Micheal D · Tolna, NDBuilt 1962 · S/N 21058117 N3618CHoshor Matthew David · Wetumpka, ALBuilt 1978 · S/N R18200278 N3618JWright David G · Lake Oswego, ORBuilt 1966 · S/N 15064918 N3619CHamby Michael R · Parma, IDBuilt 1954 · S/N 31117 N3619JFisher Ag Service LLC · Cardington, OHBuilt 1979 · S/N T18803565T N3619SFitch Aviation Holdings LLC · Pottsboro, TXBuilt 1963 · S/N 17250819 N3619YWilliams Jimmy Z · Sherman, TXBuilt 1962 · S/N 21058119 N361CCSackman Robert B · Unionville, INBuilt 1961 · S/N 17248703 N361DCSky West Aviation Inc Trustee · Albuquerque, NMS/N U20605584 N361RHDerdak Stephen · San Antonio, TXBuilt 1956 · S/N 29013 N361XSorley Steven J · Roy, UTBuilt 1957 · S/N 36238 N3620CSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N R18200279 N3620JBerens Eric A · Stevens Point, WIBuilt 1966 · S/N 15064920 N3620LMullins Lawrence D · Germantown, OHBuilt 1965 · S/N 17253789 N3620SBoese Howard · Brownell, KSBuilt 1963 · S/N 17250820 N36213N36213 Aircraft Ownership LLC · The Woodlands, TXBuilt 1975 · S/N 17702240 N3621CAirplane 1 LLC · Warren, NHBuilt 1978 · S/N R18200280 N3621JLow Cost Flying LLC · Chandler, AZBuilt 1966 · S/N 15064921 N3621SAlletto Alexander J · Russell Springs, KYBuilt 1964 · S/N 17250821

Back to AD 87-20-03 R2