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.

N734ZCGeorges Aviation Services Inc · Honolulu, HIS/N 17269236 N734ZGHorn Norman R · Las Vegas, NVBuilt 1977 · S/N 17269240 N734ZKDockins Jamie · Athol, IDBuilt 1977 · S/N 17269243 N734ZQMidway Flying Club Inc · Attleboro, MABuilt 1977 · S/N 17269248 N734ZTWatauga Eagle Squadron Foundation · Elizabethton, TNBuilt 1977 · S/N 17269251 N734ZVWesellairplanes Com Inc · Wilmington, DES/N 17269253 N734ZYWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17269256 N73502Greenbrier Valley Flyers Inc · Wht Sphr Spgs, WVBuilt 1976 · S/N 17267512 N73504Abriam Darryl · Jacksonville, FLBuilt 1976 · S/N 17267514 N73505Tex Air LLC · Springfield, MOBuilt 1976 · S/N 17267515 N73508Hoyt Max A · El Dorado, KSBuilt 1976 · S/N 17267517 N73509Saffron Skies Aviation LLC · Pleasant Hill, CAS/N 17267518 N7350GFox Victor Aviation LLC · Newnan, GABuilt 1970 · S/N 17259050 N7350HBazarnic Richard P · Tempe, AZBuilt 1981 · S/N 18267907 N7350JVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 17270592 N7350RScenic Concepts LLC · La Crosse, WIBuilt 1978 · S/N R18200646 N73510Adams Rodney G · Topinabee, MIBuilt 1976 · S/N 17267519 N73516Aviation Captial Management LLC · San Jose, CAS/N 17267524 N73519Usaeroflight LLC · Greenville, SCBuilt 1976 · S/N 17267526 N7351GMiddlebury Flying Club Inc · Middlebury, VTBuilt 1970 · S/N 17259051 N7351YDunne Brian T · Wichita, KSBuilt 1977 · S/N R18200121 N73524Dramstad Flying Service LLC · Helena, MTBuilt 1976 · S/N 17267527 N73525Magras Michael G Trustee · Sahuarita, AZBuilt 1976 · S/N 17267528 N7352DStrickland James M Jr · Whiteville, NCBuilt 1979 · S/N 17272915 N73530Saffron Aviation LLC · Cookeville, TNS/N 17267531 N73531Alcione LLC · Miami, FLBuilt 1976 · S/N 17267532 N73535Magnusson Michael J · Munnsville, NYBuilt 1976 · S/N 17267534 N7353GWoodliff Alexander Harrison · Truesdale, MOS/N 17259053 N7354GRight Rudder LLC · Rexburg, IDFirst renewal noticeBuilt 1970 · S/N 17259054 N7355GAerolanding LLC · Enterprise, ALBuilt 1970 · S/N 17259055 N73560Gospel Ministries International Inc · Collegedale, TNBuilt 1976 · S/N 17267539 N73562Steiger Michael P · Cypress, TXBuilt 1976 · S/N 17267541 N73563Hamms Lake Development Inc · Crown Point, INBuilt 1976 · S/N 17267542 N73565Thompson Teresa M · Grants Pass, ORBuilt 1976 · S/N 17267544 N7356GHolcomb John R · Siloam Springs, ARBuilt 1970 · S/N 17259056 N73573Sullins Tyler L · Boerne, TXBuilt 1976 · S/N 17267550 N73574Wingsleasing LLC · Wichita, KSBuilt 1976 · S/N 17267551 N73577Benton Frederick N · Weed, CAFirst renewal noticeBuilt 1976 · S/N 17267554 N73579Officer Properties LLC · Broken Arrow, OKBuilt 1976 · S/N 17267556 N7357CPerson Donna Mae · Columbus, NEBuilt 1980 · S/N 21063945 N73581Beaumont Ladonna L · Athol, IDBuilt 1976 · S/N 17267557 N73585Anderson Dale S · Corona, CABuilt 1976 · S/N 17267559 N7358GN7358g Inc · Las Vegas, NVBuilt 1970 · S/N 17259058 N73596Russellville Aviation Inc · Russellville, ARBuilt 1976 · S/N 17267567 N7359TKort Thomas J · Lake Tomahawk, WIBuilt 1977 · S/N R18200031 N73601Flex Air Holdings Inc · San Diego, CABuilt 1976 · S/N 17267570 N73603Davis Kevin L · Lodi, CABuilt 1976 · S/N 17267572 N73604Registration Pending · Raleigh, NCRegistration pendingBuilt 1976 · S/N 17267573 N73605Jkg LLC · Murfreesboro, TNS/N 17267574 N73610Stroup David L · Pottsboro, TXBuilt 1976 · S/N 17267576

Back to AD 80-25-07 R1