Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N82301Hudik Gary P · Chicago, ILBuilt 1982 · S/N 28R-8231061 N82306Wiseman Anamarie C · Orlando, FLBuilt 1980 · S/N 34-8070257 N8238FVip Jets Net LLC · Miami, FLBuilt 1976 · S/N 34-7770081 N8238XInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 1982 · S/N 28R8231059 N823ACPerkins Mark · Salamanca, NYBuilt 2002 · S/N 1201 N8242LWilliams Daniel M · Shawnee, KSBuilt 1980 · S/N 28R-8031148 N8242VFaulkison Brian Scott · Watkins, COBuilt 1980 · S/N 28R-8031149 N8245YViboonvutiwong Panupan · Eastvale, CABuilt 1980 · S/N 28R-8031152 N8247MChamberlain Richard Sr · Lafayette, LABuilt 1980 · S/N 28R-8031153 N8249LErickson Anesthesiology · Newburgh, INBuilt 1980 · S/N 28R-8031154 N824AAMaclennan Donald J · San Jose, CABuilt 1984 · S/N 25-0824 N824CDCat Aviation LLC · New Orleans, LABuilt 2002 · S/N 1255 N824JLSamuels John T II · Winfield, ILBuilt 1986 · S/N 25-1021 N8250DCasavannah Aviation LLC · Clearwater, FLBuilt 1980 · S/N 34-8070330 N8251EMalibu Aviation LLC · Elkhorn, WIBuilt 1980 · S/N 28R-8031156 N82525Bravo Zulu Aero LLC · Claremont, CABuilt 1982 · S/N 28R-8231068 N8252BPelican Holdings LLC · Block Island, RIBuilt 1980 · S/N 34-8070333 N8252DKennedy Carl J Jr Trustee · Gardnerville, NVBuilt 1982 · S/N 28R-8331011 N8252GJb Flight LLC · Indianapolis, INBuilt 1982 · S/N 34-8233179 N8253HAom Aircraft LLC · Orlando, FLBuilt 1980 · S/N 34-8070335 N8253PNea Aviation LLC · Gadsden, ALBuilt 1980 · S/N 34-8070337 N8256ACharlestream David · Eagle River, AKBuilt 1952 · S/N 25108 N8257YParker William E · Wichita, KSBuilt 1980 · S/N 28R-8031177 N82593Fisher Chester · Columbia, MDBuilt 1982 · S/N 28R-8231064 N8261URodriguez Nat III · Odessa, TXBuilt 1980 · S/N 34-8070351 N826VGA Bit Extra LLC · River Ridge, LABuilt 1975 · S/N 34-7570218 N8271ZDumont John · Devils Lake, NDBuilt 1982 · S/N 28R-8331001 N827ADFly By Knight Inc · Hammond, LABuilt 1979 · S/N 34-7970317 N827DBHigh Sky Aviation Inc · Wauchula, FLBuilt 2003 · S/N 3449276 N82818Miller Bryan D · Tampa, FLBuilt 1980 · S/N 34-8070263 N8284BMathews Richard A · Canyon Lake, CABuilt 1980 · S/N 28R-8131016 N8287UPhillips Harry R · Oxford, PABuilt 1982 · S/N 34-8333027 N828BJOrth Robert John · Garland, TXBuilt 1980 · S/N 28R-8031108 N82906Hunt Bryan W · Louisville, KYBuilt 1982 · S/N 28R-8231069 N8298LCenturion Flight Services Inc · Grass Valley, CABuilt 1980 · S/N 28R-8131028 N829CDAviate Piloot Academy LLC · Wichita, KSBuilt 2002 · S/N 1256 N82MGSkymasters LLC · Olathe, KSBuilt 1967 · S/N 337-0659 N82MNDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N R1722014 N8301LD M S Air LLC · Orlando, FLS/N 28R-8131035 N8303UInternational Air Service Inc Owner Trustee · Carson City, NVBuilt 1980 · S/N 348170048 N8303XDream Big Aero Corp · Wilmington, DEBuilt 1980 · S/N 34-8170049 N83047Gullo Michael · Voorhees, NJS/N 28R-8131038 N8306LStar Oil & Gas Co · Hobbs, NMBuilt 1980 · S/N 34-8170051 N8306NGularte Gavin · Berkeley, CAS/N 34-8170052 N830YDPrestige Aviation Group LLC · Orlando, FLBuilt 1976 · S/N 34-7770068 N8315ABrightwell Albert Jr · Seneca, SCBuilt 1980 · S/N 34-8170072 N8315SMagneto Consulting LLC · Grayslake, ILBuilt 1980 · S/N 28R-8131044 N83164Mavity Michael D · Phoenix, AZBuilt 1980 · S/N 28R-8131051 N8320EFerber Michael M · Parker, COBuilt 1980 · S/N 28R-8131056 N8320HBlue Oasis Flight Support · Tamarac, FLBuilt 1980 · S/N 28R-8131057

Back to AD 81-13-10 R1