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.

N60681Hendrickson Robert T · Galesburg, ILS/N 15070496 N60682Sweeney Andrew H · Murray, KYBuilt 1969 · S/N 15070497 N60684Gunnarsson Elliott Gudni · Concrete, WABuilt 1969 · S/N 15070499 N60685Barton Steven Lewis · Ventura, CABuilt 1969 · S/N 15070500 N60687Luse Benjamin T · Newalla, OKBuilt 1969 · S/N 15070501 N6068AWillerscheidt Thomas H · Mukwonago, WIBuilt 1956 · S/N 28668 N6068FStamp Michael R · Crescent City, FLBuilt 1975 · S/N 18264084 N6068GWilliams Daniel E Jr · Morehead City, NCS/N 15071568 N6068JNoble Aviation Enterprises LLC · Phoenix, AZBuilt 1975 · S/N 18263622 N60693Conaway David J · Orange Park, FLBuilt 1969 · S/N 15070506 N60694Hodgkinson David · Tolland, CTBuilt 1969 · S/N 15070507 N6069BPlane Jane Inc · Berlin, MDBuilt 1957 · S/N 34069 N6069PAirborne Helicopters LLC · Hendrum, MNBuilt 1978 · S/N P21000136 N606GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15284058 N606JCAsencio Garcia Enrique R · Fort Worth, TXBuilt 1976 · S/N 15078753 N606LPLee Andy · Riverside, CABuilt 1976 · S/N R1722020 N606PBBoillat Pascal · Olympia, WABuilt 1984 · S/N 18504423 N606RWInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 177RG0980 N606TLK C Enterprises Of Basile · Basile, LAS/N 21060545 N606TXF-22 LLC · Danbury, TXBuilt 1978 · S/N 18266763 N60701Nichols Daniel H · Helen, GAFirst renewal noticeBuilt 1969 · S/N 15070511 N60704Discover Aviation LLC · Unionville, MOS/N 15070512 N60708Registration Pending · Wentworth, MORegistration pendingS/N 15070515 N6070APolin Keith A · Belen, NMS/N 28670 N6070BLongley Tracy C · Stephenville, TXBuilt 1957 · S/N 34070 N6070FKaufman Robert L · Clarksville, TNBuilt 1975 · S/N 18264086 N6070GSimpson Michael · Chateaugay, NYBuilt 1969 · S/N 15071570 N6070JA Tumbling T Ranches · Goodyear, AZBuilt 1975 · S/N 18263624 N6070RHodgson E Russell · Nevada City, CABuilt 1965 · S/N 17253739 N60710Johnson Douglas D · Sacred Heart, MNBuilt 1976 · S/N 18052777 N60714Yoder Frederick David · Wellington, FLBuilt 1969 · S/N 15070520 N60716Evans Michael J · Greenville, MIBuilt 1969 · S/N 15070522 N6071AJones Jane · Portland, ORBuilt 1956 · S/N 28671 N6071FTweedy Daniel G · Nampa, IDBuilt 1975 · S/N 18264087 N6071KBlumhagen Myron M · Drake, NDBuilt 1975 · S/N 15077509 N60720Sedlak Christopher T · Lake City, FLBuilt 1969 · S/N 15070526 N60725Mcghie Kraig J · Sterling, AKS/N 15070527 N60729Parry Peter S · New Kent, VABuilt 1969 · S/N 15070530 N6072BTrico Mechanical Company Inc · La Fayette, GABuilt 1957 · S/N 34072 N60735Ozarks Technical Community College · Springfield, MOBuilt 1969 · S/N 15070535 N60738Long William E · Old Town, FLBuilt 1969 · S/N 15070537 N60742Greene Daniel W · Somerton, AZBuilt 1969 · S/N 15070539 N60743Cowart Frederic D · Baytown, TXBuilt 1969 · S/N 15070540 N60748Flawless Aviation LLC · Loxahatchee, FLS/N 15070544 N60749Frazier Brian D · Jackson, MSBuilt 1969 · S/N 15070545 N6074BYount Lawrence F · Shelton, WABuilt 1957 · S/N 34074 N6074RKray Timothy P · Lincoln, NEBuilt 1965 · S/N 17253743 N6074TKase Larry E · Sleepy Hollow, ILBuilt 1964 · S/N 15060774 N60756Vanjara Obaid U · San Ramon, CABuilt 1969 · S/N 15070551 N60757Follman Aviation LLC · Waterport, NYBuilt 1969 · S/N 15070552

Back to AD 87-20-03 R2