Skip to content

Registered aircraft · 25,370

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.

N2442FZeien Robert A · Charlton, MAS/N 38-79A0444 N2443FAnywhere Atp LLC · Mt Juliet, TNBuilt 1979 · S/N 38-79A0445 N2445DN5511f LLC · Voorhees, NJBuilt 1978 · S/N 38-79A0319 N2445TBurwell Jacqueline D · Potwin, KSBuilt 1978 · S/N 38-78A0804 N2446KWichita Flight Training LLC · Wichita, KSS/N 38-79A0639 N2446NPilot'S Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1979 · S/N 38-79A0847 N24472Payne Richard L · Flint Hill, VABuilt 1977 · S/N 15280272 N24477Novotny Randy · New Castle, PABuilt 1979 · S/N 38-79A1125 N2447KDamschroder Rex A · Fremont, OHBuilt 1979 · S/N 38-79A0640 N24486Wilson Seth · Shafter, CABuilt 1977 · S/N 15280283 N2448EPwc Engine Air Inc · Manorville, NYS/N 17271288 N2448KCentral Valley Flight School LLC · Hanford, CABuilt 1979 · S/N 38-79A0641 N24498Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280290 N244DAPrairie Winds Aviation LLC · Overland Park, KSBuilt 1972 · S/N 17261294 N244FRSmith Larry · Ulysses, KSBuilt 1978 · S/N 17270490 N244RTAircraftwings LLC · Las Piedras, PRS/N 17261037 N24501Dsr Cherokee 180 LLC · Dallas, TXFirst renewal noticeBuilt 1977 · S/N 15280292 N2450CCartwright Edward N · Winterville, NCBuilt 1978 · S/N 38-79A0191 N2450NBarton John S III · Gallatin, MOBuilt 1979 · S/N 38-79A0848 N24512Moran Erick A · Orange, CABuilt 1977 · S/N 15280300 N24522Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280309 N2452GFlymax Aero LLC Trustee · Dover, DEBuilt 1979 · S/N 38-79A0530 N2452TAnywhere Atp LLC · Mt Juliet, TNBuilt 1978 · S/N 38-78A0807 N2452UPuryear Rodney K · Pampa, TXBuilt 1982 · S/N 172RG1049 N24530Mayfield Jon David · Dublin, TXBuilt 1977 · S/N 15280313 N24532Christiansen Aviation LLC · Wilmington, DEBuilt 1977 · S/N 15280315 N24540Nelson Scott W · Owasso, OKS/N 38-79A1129 N24544Comer Dwayne M · Glendale, AZS/N 15280323 N24546Valestin Donald P · Queen Creek, AZBuilt 1977 · S/N 15280325 N24553Jensen Aviation LLC · Rancho Cucamonga, CABuilt 1977 · S/N 15280328 N2456DRegistered aircraftBuilt 1978 · S/N 38-79A0321 N2456NCihak Anton W II · Goode, VABuilt 1979 · S/N 38-79A0849 N2457APearce Daniel P · New River, AZS/N 38-78A0699 N2457ERegistered aircraftBuilt 1982 · S/N 18268205 N2457GKm Ed LLC · Ocala, FLS/N 38-79A0532 N2459AAretz David · Lakeland, FLBuilt 1978 · S/N 38-78A0700 N2459GNeely Darin A · Monee, ILBuilt 1979 · S/N 38-79A0534 N2459PZuberi Azhar · Poway, CAS/N 38-79A1031 N2459QBerg Gabriel · Port Angeles, WABuilt 1969 · S/N 711 N245BCBambach Gregory Alan · Manistique, MIBuilt 2018 · S/N 1175-2018 N245DAReyes Carlos E · San Juan, PRBuilt 1965 · S/N 879 N245FRChupito Sabrocito LLC · Paso Robles, CABuilt 1977 · S/N 17269686 N245SFLindley Robert F III · Williamson, GABuilt 2001 · S/N 880-2001 N24606Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A1136 N2460KL'Hommedieu Susan · Ava, MOBuilt 1979 · S/N 38-79A0643 N24611Barrios Sergio · Lusby, MDS/N 38-79A1137 N2462CPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 38-79A0197 N2462EFive Six Zero One LLC · Orange, CABuilt 1978 · S/N 17271291 N2462FBlack Coral Holdings LLC · Elm Grove, WIBuilt 1979 · S/N 38-79A0459 N2462KNicholson Michael E · Irvine, KYS/N 38-79A0646

Back to AD 80-25-07 R1