Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N57JAN57ja LLC · Quakertown, PABuilt 1979 · S/N 28-7990270 N57JJRegistration Pending · Kewaskum, WIRegistration pendingBuilt 1977 · S/N 32R-7780165 N57MARegent Trust Co Trustee · Wichita, KSBuilt 2022 · S/N 2881556 N57RKN57rk LLC · Rockwell, NCBuilt 2004 · S/N 3232016 N57RROdette David N · Thief River Falls, MNBuilt 1968 · S/N 28R-30467 N57WBBig Red Spring LLC · Fernandina Beach, FLBuilt 1983 · S/N 32R-8329034 N57WDDarling William H · Sprakers, NYBuilt 1966 · S/N 28-3395 N5803WClifford William M · North East, MDBuilt 1964 · S/N 28-1877 N5804FNoonday Sun LLC · Kensington, OHBuilt 1976 · S/N 28-7790134 N5804USand Piper Air LLC · Endicott, NYBuilt 1970 · S/N 28-26632 N5804VNationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716204 N5804WBard Nathan R · Carlisle, PABuilt 1964 · S/N 28-1895 N5805UFoxtrot Three Flying Services LLC · Henderson, NVBuilt 1970 · S/N 28-26633 N5805WPackett Robert E · Silverdale, WAFirst renewal noticeBuilt 1964 · S/N 28-1897 N5806VJolliff Herbert H · Independence, ORBuilt 1977 · S/N 28-7716205 N5808WYoung Victor G · Federal Way, WABuilt 1964 · S/N 28-1922 N5809WRegistered aircraftBuilt 1964 · S/N 28-1926 N580AGSalaita Michael Dee · Palm City, FLBuilt 2003 · S/N 3246211 N580FLWaves4days LLC · El Segundo, CABuilt 1971 · S/N 28-7125433 N580GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881191 N580JAHot Wings Aviation LLC · Indianapolis, INBuilt 2022 · S/N 28020080 N580UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020165 N5810USmith Herbert E · Rochelle, ILBuilt 1969 · S/N 28-26638 N5812USeymour Lori L · Woodstock, GABuilt 1969 · S/N 28-26641 N5812VRoark Gidion T Jr · New Roads, LAS/N 28-7790501 N5813VRose William A · Chesapeake, VABuilt 1977 · S/N 28-7790502 N5813WStothers Brian · Lake Havasu City, AZBuilt 1964 · S/N 28-1954 N5814UAnderson Timothy B · Cold Spring, KYBuilt 1970 · S/N 28-26644 N5814WP&K Enterprises LLC · Madison Heights, VABuilt 1964 · S/N 28-1965 N5815UMiller William W Jr · Henderson, NVBuilt 1969 · S/N 28-26643 N5816UHarsimran Singh · Las Vegas, NVBuilt 1970 · S/N 28-26645 N5817FWicker John E · Lexington, NCBuilt 1976 · S/N 28-7790136 N5817WDow Jeff W · Port Hadlock, WABuilt 1964 · S/N 28-1988 N5819UOn Final Aviation LLC · Brookland, ARBuilt 1970 · S/N 28-26649 N5819WKee Anthony S · Greenup, KYBuilt 1964 · S/N 28-1997 N581KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843916 N581SGOetting William C · Midland, ORS/N 3257049 N5820UScarpelli Leonard · Lakewood, ILBuilt 1970 · S/N 28-26650 N5820WRed Baron Aviation LLC · Pine Bush, NYBuilt 1964 · S/N 28-2000 N5821WEnander Johannes T · Grenora, NDS/N 28-2033 N5822UCurliss James P · Quincy, MABuilt 1970 · S/N 28-26653 N5823UNewton Donald S · Elk Grove, CABuilt 1970 · S/N 28-26654 N5823WHill Travis R · Aledo, TXBuilt 1964 · S/N 28-2070 N5824FFastaire LLC · Mobile, ALBuilt 1976 · S/N 32R-7780020 N5824ULindaman Craig C · San Luis Obispo, CABuilt 1970 · S/N 28-26655 N5824WBowman William K · Morrison, TNBuilt 1965 · S/N 28-2107 N5825TTeshima Mark William · Clovis, NMS/N 28-1595 N5825UGantz Clayton B · Forestville, CABuilt 1970 · S/N 28-26656 N5825WIndian Trucking Company Inc · Destin, FLBuilt 1965 · S/N 28-2113 N5826UHill Christopher L · Milner, GABuilt 1969 · S/N 28-26657

Back to AD 87-08-08 R3