Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N756EVOyarzo Benjamin C · Cascade, IDBuilt 1979 · S/N R18201056 N756EZBear Branch Hedeen LLC · Meridian, IDBuilt 1979 · S/N R18201058 N756FCSunny Aviation Investments Inc · San Francisco, CABuilt 1979 · S/N R18201059 N756FZM And S 182 LLC · Torrance, CAS/N R18201069 N756GEAbraham Curtis L · Byron, WYBuilt 1979 · S/N R18201071 N756GLLawrence Cyril Leonard · Merced, CABuilt 1979 · S/N R18201073 N756GYLake Superior College · Duluth, MNBuilt 1979 · S/N R18201074 N756GZGlasow Zachary · Klamath Falls, ORBuilt 1979 · S/N R18201075 N756HVGmlc Investors LLC · Santa Rosa, CAS/N R18201078 N756JBRocky Mountain Great Planes LLC · Loveland, COBuilt 1979 · S/N R18201080 N756JLN756jl LLC · Virginia Beach, VABuilt 1979 · S/N R18201082 N756JPHjs Aviation LLC · Fort Collins, COBuilt 1979 · S/N R18201083 N756JRWings Of Anglers LLC · Biloxi, MSBuilt 1979 · S/N R18201084 N756JSRedline Engineering Inc · Greenwood, CABuilt 1979 · S/N R18201085 N756JVRufus Briar Inc · Willow Spring, NCBuilt 1979 · S/N R18201087 N756JYLadnier Ronald R · Lone Tree, COBuilt 1979 · S/N R18201088 N756KQTorgerson Kristofer · Knoxville, TNS/N R18201094 N756KSSmart Ray · Burbank, CABuilt 1979 · S/N R18201096 N756KVBeckert Richard D · Lake Stevens, WABuilt 1979 · S/N R18201097 N756KZEight Two Tango Inc · Winchester, VABuilt 1979 · S/N R18201100 N756LQC2c Investments LLC · St George, UTBuilt 1979 · S/N R18201102 N756LRWingover Aviation Inc · Huntsville, ALBuilt 1979 · S/N R18201103 N756MHKlingel Jeffery S · Byron Center, MIBuilt 1979 · S/N R18201111 N756MNMoody Bible Institute Of Chicago · Spokane, WABuilt 1979 · S/N R18201116 N756NPAmerican Financial Services Inc · Las Vegas, NVBuilt 1979 · S/N R18201119 N756NYKempton Larry G · Grand Junction, COS/N R18201122 N756PBQas Mile High LLC · Los Gatos, CAS/N R18201123 N756PPB&D Aviation LLC · Bowling Green, KYBuilt 1979 · S/N R18201126 N756QKMiller Charles R · Montgomery, TXBuilt 1979 · S/N R18201129 N756QXMayfield Kyle Barnes · Ukiah, CABuilt 1979 · S/N R18201132 N756RASan Diego Skylane LLC · San Diego, CABuilt 1979 · S/N R18201133 N756RFSky Kastle LLC · Milford, OHBuilt 1979 · S/N R18201135 N756RNCrossbrook LLC · Willoughby, OHBuilt 1979 · S/N R18201137 N756RPWayman Keith M · Longmont, COBuilt 1979 · S/N R18201138 N756RVDobson Thomas J · Los Alamos, NMBuilt 1979 · S/N R18201141 N756RWAir America Trading LLC · Phoenix, AZBuilt 1979 · S/N R18201142 N756SENotus LLC · Winfield, KSBuilt 1979 · S/N R18201143 N756SWSale Reported · Basom, NYSale reportedBuilt 1979 · S/N R18201148 N756TCHazelrigg Geoffreya · Chalfont, PABuilt 1979 · S/N R18201149 N756TKG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N R18201150 N756TLMichael Maiden LLC · Sandy, ORS/N R18201151 N756TRSawyer Charles W · Marstons Mills, MABuilt 1979 · S/N R18201153 N756TUMehr David L Trustee · Mesa, AZBuilt 1979 · S/N R18201154 N756UBSayer Wayne · Bishop, CABuilt 1979 · S/N R18201156 N756UCJohnsen Ronald R · Des Moines, IAFirst renewal noticeBuilt 1979 · S/N R18201157 N756UE756ue LLC · Kalispell, MTS/N R18201158 N756UHMiller Justin · Big Sky, MTBuilt 1979 · S/N R18201159 N756VEMac Air Consulting LLC · Mesa, AZS/N R18201164 N756VHCondair Flyers Inc · Latham, NYBuilt 1979 · S/N R18201165 N756VPBurris W Tim · Tucson, AZBuilt 1979 · S/N R18201168

Back to AD 80-25-07 R1