Skip to content

Registered aircraft · 689

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:96-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13') 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:96-24-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
  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:96-24-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-24-13')
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.

N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144 N31CRStory Aranzazu · Draper, UTS/N 31-8152011 N31NWAlpha Whiskey 2 LLC · Brandon, MSBuilt 1981 · S/N 318152139 N31PNRhs Consulting Ltd LLC · Reno, NVBuilt 1976 · S/N 31P-7630009 N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049 N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059 N31TEMiller David A · Albany, ORBuilt 1984 · S/N 31-8452012 N321SJTmg Aircraft Holdings LLC · New Port Richey, FLBuilt 1977 · S/N 31-7752038 N323APEm Concordia Inc · Brooklyn, NYS/N 31-8252031 N323DDHd Security Systems LLC · Watertown, TNBuilt 1981 · S/N 31-8152170 N324ARParrish Blake · Seminole, TXS/N 31T-7620052 N325AKInternational Air Services Inc Trustee · Carson City, NVS/N 31-8112016 N325BBCapital City Curb & Gutter LLC · Wake Forest, NCBuilt 1975 · S/N 31-7512021 N325CRDiaz Aviation LLC · South New Berlin, NYBuilt 1978 · S/N 31-7912001 N325FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 31-8212005 N325FJSale Reported · Hopkinsville, KYSale reportedBuilt 1977 · S/N 31-7812007 N325JAdonai International Ministries · Marine, ILBuilt 1976 · S/N 31-7712002 N325SGTraveling Lill LLC · Key Largo, FLBuilt 1978 · S/N 317812115 N32PBLease One LLC · Lafayette, INBuilt 1981 · S/N 31-8212006 N32SBCook Robert W · Belair, MDBuilt 1976 · S/N 31-7612098 N333EJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 31-7652055 N333HFValiair Lc Trustee · Casper, WYS/N 31-8152097 N333PRGriffin Wings LLC · Lithia, FLBuilt 1973 · S/N 31-7305112 N333XXArnot Robert · Stowe, VTS/N 31T-7920038 N334RPRegistration Pending · Seneca, SCRegistration pendingBuilt 1980 · S/N 31-8052071 N336PN336p LLC · Williamstown, NJBuilt 1974 · S/N 31T-7400003 N33TLPaloma Uno LLC · Stuart, FLBuilt 1975 · S/N 31-7512043 N33URAthena Aviation LLC · Golden, MSBuilt 1980 · S/N 318052097 N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243 N348GGFlplanes 21 Of Miami LLC · Miami, FLBuilt 1980 · S/N 31-8052054 N34MIII Enterprises LLC · Britton, SDBuilt 1975 · S/N 31P-7630007 N34WM70 North LLC · Anchorage, AKBuilt 1973 · S/N 31-7305125 N350CYMowotech Inc · Boca Raton, FLBuilt 1978 · S/N 31-7852010 N350DTDestination Alaska Air Service LLC · Homer, AKBuilt 1984 · S/N 31-8452010 N350FMF M Aero Inc · Calhoun, GAS/N 31-8152043 N350GBCarto-Flight · Willoughby, OHBuilt 1980 · S/N 31-8052136 N350KCLegare Aviation LLC · Murrells Inlet, SCBuilt 1979 · S/N 317952104 N350LUValiair Limited Co Trustee · Casper, WYS/N 31-8352032 N3516AAirplane 2 LLC · Sedona, AZBuilt 1979 · S/N 31-7952106 N35187Collins Daniel W Jr · Alvarado, TXS/N 31-7912056 N3520XGv Air Inc · Medford, ORBuilt 1979 · S/N 31-7912067 N3523DQuick Gas Aviation LLC · Thomasville, GABuilt 1979 · S/N 31-7952112 N3523YL A B Flying Service Inc · Renton, WAS/N 31-7952115 N35269Marlin Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 31-7952136 N3527DKlockenga Matthew · Crystal Lake, ILS/N 31-7952137 N3527UWarbelows Air Ventures Inc · Fairbanks, AKBuilt 1979 · S/N 31-7952141 N3529AMajestic Enterprises Ltd · Wilmington, DEBuilt 1979 · S/N 31-7952152 N3529WMission Flight · El Monte, CABuilt 1979 · S/N 31-7952159 N3535SEj Hodgson Aviation Inc · Beaver Island, MIS/N 31-7952203 N3536BBering Capital LLC · Anchorage, AKBuilt 1979 · S/N 31-7952205

Back to AD 96-24-13