Skip to content

Registered aircraft · 22,416

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.

N8322WLickteig Eric Kirk Trustee · Ellensburg, WABuilt 1965 · S/N 28-2499 N83231Padilla Rafael R · Monee, ILBuilt 1980 · S/N 28-8111047 N83236Wojno Kirk J Md · Clinton Township, MIBuilt 1981 · S/N 28R-8118050 N8323AWisconsin Aviation Inc · Watertown, WIBuilt 1981 · S/N 28-8216019 N8323SOdell Ronald W · Peachtree City, GABuilt 1982 · S/N 32-8324005 N8323WConcord Aviation Services LLC · Concord, NHBuilt 1965 · S/N 28-2500 N8323YRochester Flying Club Inc · Rochester, NYBuilt 1980 · S/N 28-8111045 N8323ZChapman Farms Inc · Vernon, COBuilt 1980 · S/N 28-8111046 N8324TTango LLC · Chesterfield, MOS/N 32-8106036 N8324WSwofford Sherman A · Inman, SCBuilt 1965 · S/N 28-2501 N83259Threeway Airways LLC · Sewell, NJS/N 28-8190150 N8325CPecile Nicola · Lancaster, CABuilt 1983 · S/N 28R-8331041 N8325HArlington Flight Services Inc · Arlington, WAS/N 28-8116130 N8325LLeading Edge Flight Services Inc · Hampshire, ILBuilt 1980 · S/N 28-8116131 N8325MBerger Tara L · Fowlerville, MIS/N 28-8116132 N8325RSy Aviation LLC · Judsonia, ARS/N 28-22197 N8325TColumbia Jet Center Inc · Columbia, MOBuilt 1980 · S/N 28-8116134 N8325VPct Hawk Inc · Wilmington, DEBuilt 1980 · S/N 28-8190143 N8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 28-2502 N8326CNewman Carl D · Phoenix, AZBuilt 1980 · S/N 28-8190152 N8326WBarnwell Sam M · Traverse City, MIBuilt 1965 · S/N 28-2504 N8327BJet & Rotor Aviation LLC · Sacramento, CAS/N 28R-8131071 N8327HR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1980 · S/N 28R-8131072 N8327LFill David · Hadley, MABuilt 1980 · S/N 28-8111049 N8327RWelsh Rick F · Ewing, VABuilt 1966 · S/N 28-22199 N8327WFuture Flying LLC · Manassas, VABuilt 1965 · S/N 28-2506 N8327ZLee Steven M · Redondo Beach, CAS/N 32-8124007 N8328CSky Craft LLC · Powell, OHBuilt 1975 · S/N 28-7690116 N8328DJldp LLC · Chesapeake, VABuilt 1981 · S/N 32R-8129035 N8328WTolmachev Nikolay A · Anchorage, AKBuilt 1965 · S/N 28-2507 N8329WWeber Todd M · Robinson, ILS/N 28-8111043 N832EKPiper Aircraft Inc · Vero Beach, FLS/N 28020289 N832FCFlycarolina LLC · Concord, NCBuilt 1981 · S/N 28R-8118051 N832JAMoore Jimmy L · Beach City, TXBuilt 1979 · S/N 28R7931187 N832SPRiverside Exteriors Inc · Kalispell, MTBuilt 1983 · S/N 32R-8313001 N832TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881706 N8330LParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8116141 N8330RBriggs Michael L · Howell, MIBuilt 1966 · S/N 28-22202 N8330WRed Rock Flying School LLC · Mesa, AZS/N 28-2510 N8330XHamilton Eddie D · North East, MDBuilt 1980 · S/N 28-8190153 N8330ZLuzeski Steven · Collegeville, PABuilt 1980 · S/N 28-8190155 N8331CRoanoke Valley Flying Club · Roanoke, VABuilt 1975 · S/N 28-7690117 N8331EPats Sales Of Ocala LLC · Ocala, FLBuilt 1981 · S/N 32-8124008 N8331SFly Aviation Corp · Wilmington, DEBuilt 1982 · S/N 28-8316028 N8331ULenz Piper LLC · Camdenton, MOS/N 32R-8129037 N8332BBeckham Brett A · Anson, TXBuilt 1980 · S/N 28R-8031088 N8332CKyro Kevin D · Lakeville, MNS/N 28R-7635148 N8332HCrosswinds Flying Club Inc · Bloomington, ILBuilt 1981 · S/N 28-8190158 N8332RDelehanty Sean M · Mattituck, NYBuilt 1966 · S/N 28-22204 N8332WSurls Aviation Inc · Peculiar, MOBuilt 1965 · S/N 28-2512

Back to AD 87-08-08 R3