Skip to content

Registered aircraft · 72,007

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-10-06-R1') 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-10-06-R1') 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-10-06-R1')
    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-10-06-R1')
  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-10-06-R1')
  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-10-06-R1')
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.

N3060RArrow N3060r LLC · Sheridan, WYBuilt 1969 · S/N 28R-35621 N3060YB&D Flight Club LLC · Portage, INBuilt 1979 · S/N 28-7916370 N30612Wheeler Vincent · Harwinton, CTBuilt 1969 · S/N 17701360 N30615Yanichko Robert · Weeki Wachee, FLBuilt 1969 · S/N 17701362 N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149 N3061RCohns Willie · Elizabethtown, KYBuilt 1969 · S/N 28R-35622 N3061WCcn Air LLC · Bloomington, INBuilt 1979 · S/N 32-7940079 N3061YHott Steven A · Kokomo, INBuilt 1979 · S/N 28-7990388 N3061ZKell Thomas G · Anchorage, AKS/N 22-7016 N30622Money Aerial Media LLC · San Diego, CABuilt 1940 · S/N 5-223 N30626Hoese Ray D · San Antonio, TXBuilt 1969 · S/N 17701368 N3062LMerino Rodrigo R · Chilton, WIBuilt 1979 · S/N 28-7916252 N3062RBuddys Aviation LLC · East Bernstadt, KYBuilt 1979 · S/N 32R-7985084 N3062SRiver City Aviation LLC · Carmichael, CABuilt 1967 · S/N 15066962 N3062WD M Aviation II Llp · Park River, NDBuilt 1979 · S/N 32-7940080 N3062YSwaringen Jeanne A · Lakeside, CABuilt 1979 · S/N 28-7990389 N3062ZSchofield Wayne D · Polson, MTBuilt 1959 · S/N 22-7017 N30630Erickson Keith E · Anchorage, AKS/N 17701369 N30632Evv Pilots Club Inc · Evansville, INFirst renewal noticeBuilt 1969 · S/N 17701371 N30634Beck Alan · Las Vegas, NVBuilt 1969 · S/N 17701372 N30636Schub William C · Oakdale, NYBuilt 1969 · S/N 17701373 N30637Diamond Paul · Londonderry, NHBuilt 1969 · S/N 17701374 N30639Madden Michael A Trustee · De Pere, WIBuilt 1969 · S/N 17701375 N3063PWillis William P Trustee · New Palestine, INS/N 23-981 N3063RGrant Scott A · Santa Barbara, CABuilt 1969 · S/N 28R-35624 N3063ZSeiter Randy R · Lake Isabella, MIBuilt 1959 · S/N 22-7018 N30643Hurst Gordon · Waterford, PABuilt 1974 · S/N 17264150 N30647Registration Pending · Diamondhead, MSRegistration pendingBuilt 1978 · S/N 28-7816545 N3064ZReichlin Richard S · Traverse City, MIBuilt 1959 · S/N 22-7019 N30650Elite Flight Training And Aircraft Management LLC · Kankakee, ILBuilt 1978 · S/N 28-7916089 N30654Eagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701386 N30656Vance Matthew Austin · Decatur, GABuilt 1969 · S/N 17701387 N30658Mcmahan Jerry · Watson, ARBuilt 1940 · S/N 5-228 N3065BVanator John D · Eaton Rapids, MIBuilt 1978 · S/N 32R-7987043 N3065CVenture West LLC · Mesa, AZBuilt 1978 · S/N 28-7990152 N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425 N3065KBowles William Jr · New Richmond, OHBuilt 1978 · S/N 28R-7918003 N3065RFlavin Patrick J · Woodbridge, VABuilt 1969 · S/N 28R-35626 N30661Feiler Joe · Casper, WYBuilt 1969 · S/N 17701389 N30662Jandair LLC · Ennis, TXBuilt 2004 · S/N 3255023 N30663Kroeker Bryan S · Grant, NEBuilt 1969 · S/N 17701391 N30668Elevation Aviation LLC · Mccomb, MSBuilt 1969 · S/N 17701394 N3066GAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7990197 N3066HLarsen Mark S · Spencer, IABuilt 1978 · S/N 28-7916219 N3066KQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7918005 N3066PMatanane Rokie C · Barrigada, GUBuilt 1957 · S/N 23-984 N3066RParker Michael A · Milwaukee, WIBuilt 1969 · S/N 28R-35628 N3066UAjh Aviation LLC · Monroe, LABuilt 2004 · S/N 3257341 N3066YQuiett Aaron Trustee · Hillsboro, ORS/N 28-7990392 N30670Brown Thomas E · Trenton, GABuilt 1969 · S/N 17701395

Back to AD 87-10-06 R1