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.

N236PAGreene James · Hudson, SDBuilt 1978 · S/N 28-7816679 N236PDHeitz Kenneth Joe · Boynton Beach, FLBuilt 1979 · S/N 28-8011029 N236PMCummings Ralph L · Rmv, CABuilt 1982 · S/N 28-8211032 N236PRConnecticut Flyers Inc · Madison, CTBuilt 1979 · S/N 28-7911272 N236SHAir 2 Sea LLC · Martin, TNBuilt 1979 · S/N 28-7911169 N236TTPoole Mark · Meriden, CTBuilt 1981 · S/N 32R-8113110 N236ZKMaximum Ceiling Aviation LLC · Farmingdale, NYS/N 2843401 N2371TThomas Jacob W · Loris, SCS/N 28-7225056 N2373TNeuharth Randall H · Norfolk, NEBuilt 1971 · S/N 28-7225003 N2374TFlying High Investments LLC DBA · Winnemucca, NVBuilt 1971 · S/N 28-7225017 N2375MValentine Ronald F Jr · Santa Maria, CABuilt 1977 · S/N 28-7816280 N2376TStranberg Ray L · Bakersfield, CAS/N 28-7225057 N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021 N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059 N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022 N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230 N237FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2842015 N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815 N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249 N2380TRegistered aircraftS/N 28-7225060 N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031 N2384RMonroe Joel L · Alexandria, MNBuilt 1971 · S/N 28-7110003 N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064 N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602 N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065 N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175 N238MCBrotherton Douglas E Trustee · Dubuque, IABuilt 1993 · S/N 3213047 N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816 N238NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842101 N238TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020238 N238WMMchatton Dret A · Redding, CABuilt 1967 · S/N 28-10924 N2390TKessler Derek D · Lexington, OKS/N 28-7225068 N2391QNew Hamphire Flyers LLC · Lyme, NHBuilt 1977 · S/N 28-7790395 N2391TLotnicza LLC · Houston, TXBuilt 1971 · S/N 28-7225069 N2391UJeffway Robert W Jr · Leeds, MABuilt 1979 · S/N 32-7940253 N2392QTwin Eagle Flying Club Inc · Pikeville, KYBuilt 1977 · S/N 28-7790396 N2393TShool Board Of Marion County Florida · Ocala, FLBuilt 1971 · S/N 28-7225066 N2394MOld Buzzard Ltd · Columbus, OHBuilt 1977 · S/N 28R-7837085 N2395TSingh Harsimran · Las Vegas, NVBuilt 1971 · S/N 28-7205049 N2395VConfluence Systems Consulting Inc · San Jose, CAS/N 28-8590069 N2397TSound Approach Aviation LLC · Seattle, WABuilt 1971 · S/N 28-7225070 N2399TThompson Nolan E · Houston, TXBuilt 1971 · S/N 28-7205052 N239AShiloh Flite Five · Eden, NCBuilt 1996 · S/N 3246022 N239CWolvestown LLC · Humble, TXBuilt 2003 · S/N 2843581 N239JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020009 N239MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881868 N239NDPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842100 N239STN239st LLC · Peachtree City, GABuilt 2006 · S/N 3246239 N23AFGuilded Gull Aviation LLC · Middletown, RIBuilt 1974 · S/N 28-7415702 N23ALPv Aviation LLC · Poland, OHBuilt 1981 · S/N 32R-8213008

Back to AD 87-08-08 R3