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.

N5875RHepburn Joseph C · Towanda, KSBuilt 1965 · S/N 17253544 N58763Downwind LLC · Clancy, MTBuilt 1973 · S/N 18262280 N58766Gonzalez Tomas · Windham, NHBuilt 1973 · S/N 18262282 N5876AThomas Christopher D · Santa Monica, CABuilt 1956 · S/N 28476 N5876RJasmer Craig G · Puyallup, WABuilt 1965 · S/N 17253545 N58771Casas-Dolz Raul · Dickinson, NDBuilt 1973 · S/N 18262284 N58773Ranchers Skylane LLC · Newcastle, WYBuilt 1973 · S/N 18262286 N58776Wild River Flying Club Inc · Saint Croix Falls, WIBuilt 1973 · S/N 18262288 N58778Bell Bradley J · Searcy, ARBuilt 1973 · S/N 18262290 N5877AMangham Aviation LLC · Mullin, TXBuilt 1956 · S/N 28477 N5877GClegg Stephen A · Port Orange, FLBuilt 1969 · S/N 15071377 N5877RRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1965 · S/N 17253546 N5877TLeaders Kurt W · Clear Lake, MNS/N 185-0777 N58780Sksp LLC · Brandon, FLBuilt 1973 · S/N 18262291 N5878BRobel Timothy R · Yakima, WABuilt 1956 · S/N 33878 N5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 17271949 N5878FVanreeth Philip J Jr · Woodstock, ILBuilt 1967 · S/N 21058878 N58790Ego IV Aviation Consulting LLC · Goose Creek, SCBuilt 1973 · S/N 18262295 N58793Summers Randall L · Weslaco, TXBuilt 1973 · S/N 18262298 N58794Lagos Ricardo · Seattle, WABuilt 1973 · S/N 18262299 N58798Tailwind Aviation Holdings LLC · Austin, TXS/N 18262303 N587BCBlacow Kenneth Michael · Key West, FLBuilt 1979 · S/N 18267419 N58800S&Hb Sky LLC · Heyburn, IDBuilt 1973 · S/N 18262304 N5880ENashville Skyscrapers LLC · Old Hickory, TNBuilt 1978 · S/N 17271950 N58812F And L Properties · Magnolia, ARBuilt 1973 · S/N 18262312 N58818Jk Homes LLC · Idaho Falls, IDS/N 18262317 N5881RRengel Ronald J · Mundelein, ILBuilt 1965 · S/N 17253550 N58821Canipe Rachel B · Shelby, NCBuilt 1973 · S/N 18262319 N58823Silverbullet LLC · San Francisco, CABuilt 1973 · S/N 18262321 N5882BValley Air Inc · Natchitoches, LAFirst renewal noticeBuilt 1956 · S/N 33882 N5882RGrow Aviation LLC · Aurora, NEBuilt 1965 · S/N 17253551 N58830Frisbee Ralph · Valley Park, MSBuilt 1973 · S/N 18262326 N58832Wiley Eleven Eleven Ltd · Hayward, WIBuilt 1973 · S/N 18262328 N5883GDerry Delmar D · New Market, IABuilt 1969 · S/N 15071383 N58843Kcn Aero Club Inc · Overland Park, KSBuilt 1973 · S/N 18262335 N5884ADe Witt Duane A · Colleyville, TXBuilt 1956 · S/N 28484 N58851Crimm Sam II · Tullahoma, TNBuilt 1973 · S/N 18262342 N58852Backcountry Wagons LLC · Kalispell, MTBuilt 1973 · S/N 18262343 N58853Moulin Neil D · Harrah, OKBuilt 1973 · S/N 18262344 N58859Corby David J · Richmond, MIBuilt 1973 · S/N 18262348 N5885BGottlieb Kevin L · Anchorage, AKBuilt 1956 · S/N 33885 N5885TSale Reported · Cleveland, GASale reportedS/N 185-0785 N58860Rentz Jimmy L · Bainbridge, GABuilt 1973 · S/N 18262349 N58865Fairhill Properties LLC · Valley City, NDBuilt 1973 · S/N 18262354 N58866R And M Steel Company · Caldwell, IDBuilt 1973 · S/N 18262355 N5886BSchramm Craig O · Fenton, MIBuilt 1956 · S/N 33886 N5886RZimmer James D · Mason City, NEBuilt 1965 · S/N 17253555 N58873Carman Steven W · Grass Valley, CABuilt 1973 · S/N 18262362 N58877Executive Flight LLC · Greenwood, MSBuilt 1973 · S/N 18262366 N5887BRedden Timothy Ray · Citrus Heights, CABuilt 1956 · S/N 33887

Back to AD 87-20-03 R2