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.

N8378LLett Brian R · Eden Prairie, MNBuilt 1968 · S/N 17256578 N8378VDollins Carl E · Grosse Ile, MIBuilt 1966 · S/N 486 N8379LSan Fernando Aviation LLC · Van Nuys, CAS/N 17256579 N8380VMaxwell Frank R · Fairbanks, AKBuilt 1966 · S/N 70 N8381LShielded Holdings LLC - Series Av 12 · Katy, TXBuilt 1968 · S/N 17256581 N8382LMedina Solla Edwin O · Trujillo Alto, PRBuilt 1968 · S/N 17256582 N8385LKrebs Lisa Christine · Homer, AKBuilt 1968 · S/N 17256585 N8386LAdams Haidyn · Pentwater, MIS/N 17256586 N8387LSerra Christopher R · Snellville, GABuilt 1968 · S/N 17256587 N8387VN8387v LLC · Lansing, MIBuilt 1966 · S/N 507 N8389LJkg LLC · Murfreesboro, TNBuilt 1968 · S/N 17256589 N8389VNelzen Wayne K · Mulino, ORBuilt 1966 · S/N 529 N838BCN838bc LLC · Naperville, ILBuilt 2025 · S/N 1223-2025 N838HGVanmeetern Robert · Reedsburg, WIBuilt 1985 · S/N 24-1566 N838MPWhitney Stephen · Fort Myers, FLS/N 17258274 N8390LBliss Marketing Communications Inc · Phoenix, AZBuilt 1968 · S/N 17256590 N8390VMapel Roger N · Weirton, WVBuilt 1966 · S/N 537 N8391VRoflyco Ltd · Glendale, AZBuilt 1966 · S/N 107 N8393LJohns Ryan · Sabillasville, MDBuilt 1968 · S/N 17256593 N8395VVandeman Jack A · Norco, CABuilt 1966 · S/N 530 N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598 N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599 N839HFFour Boys Flying LLC · Kalispell, MTBuilt 1980 · S/N P21000633 N83BMShelton David B · Dallas, TXBuilt 1983 · S/N 21064799 N83CEElsner Kelly J · Menahga, MNBuilt 1980 · S/N P21000578 N83DHHansen Douglas M · Garden City, SDBuilt 1997 · S/N 786-96 N83EWTremarco Philip J · Anchorage, AKS/N 17261231 N83FPPhillips Tom Scott · Beach City, TXBuilt 1978 · S/N 17271377 N83PRRegistration Pending · Downingtown, PARegistration pendingBuilt 1964 · S/N 367 N83SWRogers Gary A · Novi, MIBuilt 1979 · S/N R18200625 N83TMCimino Joseph Michael · Decatur, ALBuilt 1977 · S/N A1520748 N84009Swenson Catherine A Trustee · Meadow Vista, CABuilt 1969 · S/N 17258299 N8400LInstant Print Signs & Designs LLC · Kalispell, MTBuilt 1968 · S/N 17256600 N84019Snodgrass William D · Moberly, MOFirst renewal noticeBuilt 1969 · S/N 17258303 N8401LBlack Baron Air LLC · Kalispell, MTS/N 17256601 N84024Maurano Michael R · Long Island, VABuilt 1969 · S/N 17258304 N84026Smith William A Jr · Tulsa, OKBuilt 1969 · S/N 17258305 N8402LVan Bortel Inc · Victor, NYBuilt 1968 · S/N 17256602 N84036Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258308 N84048Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 17258314 N84050Alpenglow Air 2 LLC · Anchorage, AKBuilt 1969 · S/N 17258315 N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319 N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322 N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323 N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326 N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327

Back to AD 80-25-07 R1