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.

N757TLSky Candy LLC · Scottsdale, AZBuilt 1977 · S/N 15279991 N757TVTri County Rentals And Sales Inc · Lake City, FLBuilt 1977 · S/N 15280000 N757UGehret Barry · Sonoma, CABuilt 1965 · S/N 933 N757UDDau Anuar · Colfax, NCBuilt 1977 · S/N 15280007 N757UFAviation Capital Management LLC · San Jose, CABuilt 1977 · S/N 15280009 N757URRichmor Aviation Inc · Hudson, NYBuilt 1977 · S/N 15280018 N757USPeasley Robert E · Lonsdale, MNBuilt 2019 · S/N 526-2019 N757UTIfly LLC · Wichita, KSBuilt 1977 · S/N 15280020 N757UZCoulliette Brian K · Jacksonville, FLBuilt 1977 · S/N 15280026 N757VAStoup Lyndal K · Cordell, OKS/N 15280027 N757VBGanesh Prabhandhakavi · Cerritos, CABuilt 1977 · S/N 15280028 N757VVTechnical Education Services Inc T/A · Virginia Beach, VAS/N 15280046 N757VWHeckert Dale L · Nikiski, AKBuilt 1977 · S/N 15280047 N757VYRice Timyn J · Saint Petersburg, FLBuilt 1979 · S/N R18201268 N757WBReineke John S · Powell, OHBuilt 1979 · S/N R18201269 N757WPAero Fliers LLC · Kalispell, MTS/N 15280064 N757WTElectrical Management Services · North Andover, MABuilt 1979 · S/N R18201230 N757XDSouth Texas War Birds LLC · Santa Fe, TXBuilt 1979 · S/N R18201272 N757XGJohnson Shawn A · Joliet, MTBuilt 1977 · S/N 15280081 N757XHSteinhauser Raymond P · Ashland, OHBuilt 1977 · S/N 15280082 N757XUHighflight Inc · Perkinsville, VTBuilt 1979 · S/N R18201273 N757XWPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1977 · S/N 15280095 N757YARule John D · Nampa, IDS/N 15280099 N757YGDayton Pilots Club Inc · Springboro, OHBuilt 1979 · S/N R18201274 N757YHKnutson Wayne R · Thompson, NDFirst renewal noticeS/N 15280106 N757YMDarcy Aviation LLC · Danbury, CTS/N 15280110 N757YSJohn Mccaskill Enterprises LLC · Tifton, GABuilt 1977 · S/N 15280115 N757YUTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1977 · S/N 15280117 N757ZAAdventure Flight Aviation Inc · Springdale, ARBuilt 1977 · S/N 15280123 N757ZFProbasco Mitchell L · Floydada, TXS/N 15280128 N757ZNJin Jin Aviation LLC · Anchorage, AKBuilt 1977 · S/N 15280135 N757ZRBishops' Ltd · Virginia Beach, VABuilt 1977 · S/N 15280138 N757ZSDevereaux Mishelle · Raleigh, NCBuilt 1977 · S/N 15280139 N757ZTRiya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280140 N757ZUUniversity Flying Club Inc · Orono, MES/N 15280141 N75801Hartland Aviation LLC · New Smyrna Beach, FLBuilt 1976 · S/N 17267960 N75803Kuntz Donald Alan · Whitefish, MTBuilt 1976 · S/N 17267962 N75805Roney Howard D · Salem, ORBuilt 1976 · S/N 17267964 N75806Jones Bros Amc Jeep Inc · Harrison, ARBuilt 1976 · S/N 17267965 N75807Pearl River Community College · Poplarville, MSS/N 17267966 N75809C & S Flyers LLC · Grand Lake, LABuilt 1976 · S/N 17267967 N7580FLybbert Randal Lorin · Moses Lake, WAS/N 736-70 N7580TBushgoair LLC · Chicago, ILBuilt 1978 · S/N R18200043 N7580VBinzel Charles P · Bristol, WIBuilt 1976 · S/N 177RG0871 N75816Lns Aviation LLC · Chandler, AZBuilt 1976 · S/N 17267973 N7581GManasco Inc · Tucson, AZBuilt 1970 · S/N 17259281 N7581VJacoby Billy L · The Villages, FLS/N 177RG0872 N75820Zoviv Michael · Hollywood, FLBuilt 1976 · S/N 17267977 N75822International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 17267979 N75823Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17267980

Back to AD 80-25-07 R1