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.

N370WCInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 32-7840196 N3710KBlack Dragon87 LLC · Milford, CTBuilt 1967 · S/N 28-23701 N3710MPrisbe Ernest · Los Altos Hills, CABuilt 1998 · S/N 3257039 N3710WPdr LLC · Royal Palm Beach, FLFirst renewal noticeS/N 32-623 N3711Gratech Management LLC · Washington, NCBuilt 1967 · S/N 28R-30015 N3712RMcbride Charles E · Omaha, NEBuilt 1970 · S/N 28-5798 N3713K3713 Kilo LLC · Athens, GAS/N 28-23702 N3713WRvn Trucking LLC · Tilden, NEBuilt 1966 · S/N 32-626 N3716RDavey Richard T II · Imperial, CABuilt 1970 · S/N 28-5484 N3716TN351xray LLC · Olga, WAS/N 28R-30021 N3716WRobb Air LLC · Escalon, CAS/N 32-629 N3717RHealdsburg Aviation · Healdsburg, CABuilt 1970 · S/N 28-5807 N3718MFink Gary L · Klamath Falls, ORBuilt 1978 · S/N 28-7890325 N3718RConklin Loy L · Browns Valley, CABuilt 1970 · S/N 28-5808 N3718TRuder William A Jr · Council Bluffs, IAS/N 28R-30023 N371BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881771 N371DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842189 N371MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881803 N371SAJoshua Leo · Midway, GABuilt 1966 · S/N 28-22550 N3720TBrinmoore Aero LLC · Jacksonville, FLBuilt 1967 · S/N 28R-30025 N3721WFiumerodo Flavio · Tarzana, CABuilt 1966 · S/N 32-633 N3722MRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7890326 N3722XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881011 N3723XBig Bend Community College · Moses Lake, WABuilt 2018 · S/N 2881012 N3724KTreharne Russell C · Fruita, COBuilt 1967 · S/N 28-23703 N3724MRegistration Pending · Greenville, SCRegistration pendingBuilt 1978 · S/N 28-7890327 N3724TGateway Flight Training LLC · Saint Louis, MOBuilt 1967 · S/N 28R-30030 N3725RSoutheastern Business Machines Inc · Baxley, GABuilt 1970 · S/N 28-5810 N3725WKosko Stanley G · Seattle, WABuilt 1966 · S/N 32-638 N3727TN3727 Tango LLC · Baton Rouge, LABuilt 1967 · S/N 28R-30034 N3727WTriple C Air LLC · Madison, GABuilt 1966 · S/N 32-640 N3728WGalactic Air LLC · Ringoes, NJBuilt 1966 · S/N 32-641 N3729WColeman James C III · Saint Augustine, FLBuilt 1966 · S/N 32-642 N372HPPlumbob LLC · Wilmington, DES/N 3246190 N372MABenham Properties LLC · Sullivan, INBuilt 2000 · S/N 3246172 N372MKNorth Star Aviation Inc · Mankato, MNBuilt 2024 · S/N 2881804 N3730KCloutier Felix S · Fond Du Lac, WIBuilt 1967 · S/N 28-23708 N3730MWilcom LLC · Hammond, LABuilt 1978 · S/N 28R-7837133 N3730TNational Energy Conservers Inc · West Linn, ORBuilt 1967 · S/N 28R-30037 N3730WEye South Equipment LLC · Greenwood, MSBuilt 1966 · S/N 32-644 N3731MZim Air LLC · Wilmington, DEBuilt 1978 · S/N 28R-7803189 N3732TOancea Traian · Oakdale, CABuilt 1967 · S/N 28R-30040 N3733TTudor David M · Seaford, DEBuilt 1967 · S/N 28R-30041 N3736KBloom Cory G · Indianola, IABuilt 1967 · S/N 28-23713 N3736TVelivis Bernard K · Hollis, NHBuilt 1967 · S/N 28R-30045 N3736WLarsen Christopher R · West Melbourne, FLBuilt 1966 · S/N 32-650 N3737MMathur Arvind Kishore · Hemet, CABuilt 1978 · S/N 32-7840071 N3737TKenny David Jack · Frederick, MDBuilt 1967 · S/N 28R-30046 N3737WVoss James S · Soldotna, AKS/N 32-651 N3738MAnsell Nathan D · Mukwonago, WIS/N 32R-7885013

Back to AD 87-08-08 R3