Skip to content

Registered aircraft · 54,019

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.

N2019ECox Garry G · Coleman, TXS/N 17271120 N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987 N2019XZarracina Robert · Stillwater, MNS/N 18256119 N2019YThuet Robert C · Spartanburg, SCBuilt 1962 · S/N 17249519 N201CLWings Aero Club LLC · Union Hall, VABuilt 1967 · S/N 18258712 N201EXPennington Sonja · Tutwiler, MSBuilt 1966 · S/N 18257642 N201SHRyan L Phillips Inc · Campobello, SCBuilt 1973 · S/N 18262073 N20201Castillo Frank E · San Jose, CABuilt 1972 · S/N 17261091 N20202Lolani Leasing LLC · Los Angeles, CABuilt 1972 · S/N 17261092 N20203Wannenburg Thomas · Atlantic Beach, FLBuilt 1972 · S/N 17261093 N20204Bellingham James G · Baltimore, MDBuilt 1977 · S/N 17702644 N20207Disheroon Donald · Houston, TXS/N 17261095 N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096 N2020GLyon John · Santa Barbara, CABuilt 1958 · S/N 51320 N2020XCullman Aviation Inc · Cullman, ALBuilt 1965 · S/N 18256120 N2020ZAbrahamson Nicholas P II · Grosse Ile, MIBuilt 1963 · S/N 15059820 N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098 N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099 N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645 N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101 N20216Manke Derek E · Canton, GABuilt 1972 · S/N 17261102 N20217La Valle Jacque D · Lexington Park, MDBuilt 1977 · S/N 17702646 N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104 N20219Koenitzer Judson B · Chetek, WIS/N 17261105 N2021QHamilton Gregory J · Avon Lake, OHBuilt 1973 · S/N 177RG0421 N2021ZMclean Jr Rufus C · Rockingham, NCBuilt 1963 · S/N 15059821 N20221Ohair Mark O · Lampasas, TXFirst renewal noticeBuilt 1972 · S/N 177RG0273 N20222Coe Douglas R · Roswell, GAS/N 17702647 N20223Roberts Stephen Wade · Friendswood, TXBuilt 1977 · S/N 17702648 N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110 N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111 N20229Sale Reported · Wilmington, DESale reportedS/N 17702649 N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115 N20232Lopez Tail Draggers LLC · Lopez Island, WABuilt 1972 · S/N 17261116 N20233Jenkins Robert W · Fredericktown, OHBuilt 1972 · S/N 17261117 N20236Safety In Motion Flight Center Inc · Puyallup, WAS/N 17261120 N20237Shortway Pilots Inc · Clearfield, PABuilt 1977 · S/N 17702650 N20238Valenti Jeffery N · Eastport, NYBuilt 1973 · S/N 17261122 N2023XZim Sim LLC · Charleston, SCBuilt 1965 · S/N 18256123 N2023YCassero Ronald V · Santa Rosa, CABuilt 1962 · S/N 17249523 N20241Aviation 241 Inc · North Lima, OHBuilt 1972 · S/N 17261124 N20242Gent John F · Wellman, IABuilt 1972 · S/N 17261125 N20243Webb John W · Elkins, WVBuilt 1972 · S/N 17261126 N20246Olek Brad · New Richmond, WIBuilt 1972 · S/N 17261127 N20247Grace Ellen M · Bloomville, NYBuilt 1972 · S/N 17261128 N2024SRegistration Pending · Sublette, KSRegistration pendingS/N R18201285 N2024XMahaney Nicholas · Tahlequah, OKBuilt 1965 · S/N 18256124 N20250Kooistra Samuel R · Honobia, OKBuilt 1972 · S/N 17261131 N20251Granahan Eric J · Burlington, WIBuilt 1972 · S/N 17261132 N20252Morino William D · Palos Verdes Est, CABuilt 1981 · S/N 18053183

Back to AD 87-20-03 R2