Skip to content

Registered aircraft · 25,368

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.

N8966VCreider Paul E · Tulsa, OKBuilt 1974 · S/N 17264322 N89681Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282824 N8968VLittle Gordon D · Watertown, SDS/N 17264324 N89693Rjw Aviation LLC · Tampa, FLBuilt 1978 · S/N 15282827 N8969VCrowley Brett A · Wasilla, AKS/N 17264325 N89702Carter Flygare Inc · Sacramento, CABuilt 1978 · S/N 15282830 N8970VWinding Creek Aviation LLC · Snellville, GABuilt 1974 · S/N 17264326 N89718Schad Paul E · Gainesville, TXBuilt 1978 · S/N 15282839 N8971MDixon Gary Lynn II · Ooltewah, TNBuilt 1973 · S/N 177RG0371 N8971VGibson Aviation Services LLC · Hudson, WIBuilt 1974 · S/N 17264327 N89721Propability One LLC · Daytona Beach, FLBuilt 1983 · S/N 17276010 N89727Wings Over Texas Holdings LLC · Denton, TXS/N 15282844 N8972VPearce Michael J · Phoenix, AZBuilt 1974 · S/N 17264328 N89735N89735 LLC · Stuart, FLBuilt 1978 · S/N 15282847 N8973VOcean Flyers LLC · Chatham, NJBuilt 1974 · S/N 17264329 N89743Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282850 N89753Aerohead Planes LLC · Savannah, GAS/N 15282853 N8975VMauser James E · Zionsville, PABuilt 1974 · S/N 17264331 N89764South Aero LLC · Albuquerque, NMS/N 15282857 N89770Seals Richard W · Torrance, CAS/N 15282860 N89780Huffman Jacob M III · Burleson, TXBuilt 1978 · S/N 15282865 N8979VAvel Aircraft Inc · West Chicago, ILBuilt 1974 · S/N 17264335 N897AHAerospace Asset Holdings LLC · Wilmington, DES/N 21064163 N89800Ballesteros Irlena · Glendale, CAS/N 15282872 N8980VSweitz-Air Inc · Stewartstown, PAS/N 17264336 N89811Sky Warrior Flight Training Inc · Pensacola, FLBuilt 1983 · S/N 17276013 N89812Fremont Aviation Inc · Fremont, NEBuilt 1978 · S/N 15282879 N89815Pinnacle Aviation Services Inc · Encinitas, CABuilt 1978 · S/N 15282881 N8982VHirsch John K Trustee · Gerald, MOBuilt 1974 · S/N 17264338 N8983VMoon Reagan E · Bossier City, LABuilt 1974 · S/N 17264339 N89859Hess Garrett J · Fullerton, CABuilt 1978 · S/N 15282894 N89863Ruess Richard M · Anchorage, AKBuilt 1978 · S/N 15282896 N89869Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282897 N8986VAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17264342 N89877Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282900 N89878Corwin Shawn M · Tucson, AZBuilt 1983 · S/N 17276015 N8987VPiper Capital Growth Fund LLC · Scottsdale, AZBuilt 1974 · S/N 17264343 N89881Fulton Gene · Spartanburg, SCBuilt 1978 · S/N 15282903 N89887Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15282904 N8988VWahle Daniel C · Missoula, MTBuilt 1974 · S/N 17264344 N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108 N898TKatz Air Holdings LLC · Wilmington, DEBuilt 2024 · S/N 641-2024 N8992VFreeze Otis C · Frankston, TXBuilt 1974 · S/N 17264347 N89933Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282920 N89934Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282921 N8993VBmg Aviation Leasing LLC · Bloomington, INBuilt 1974 · S/N 17264348 N89963Wardall Wesley David · Ione, CABuilt 1978 · S/N 15282931 N8996VBaumgartner Scot W · Colby, WIBuilt 1974 · S/N 17264351 N8997VHusker-Hawkeye Distributing Inc DBA · Omaha, NEBuilt 1974 · S/N 17264352 N89980Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282937

Back to AD 80-25-07 R1