Skip to content

Registered aircraft · 18,497

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

N5834KVandagriff Phillip H · Kingwood, TXBuilt 1965 · S/N D-7845 N5835KAdee Bret L · Toronto, SDBuilt 1965 · S/N D-7846 N5835SStiles David W · Saint Petersburg, FLBuilt 1964 · S/N D-7734 N5836JMeyerkorth Aviation LLC · Rock Port, MOBuilt 1970 · S/N 18501805 N5838KSullivan Jesse G · Yukon, OKBuilt 1965 · S/N D-7838 N5839SFox Alan D · Cherry Hill, NJBuilt 1964 · S/N D-7736 N583CFFox Aviation LLC · Hattiesburg, MSBuilt 1997 · S/N LIV143 N583CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N TH-1291 N583KCrazy Mountains Aviation LLC · Columbus, GABuilt 2007 · S/N E-3820 N583MGZazworsky John D Jr · Mechanicsburg, PABuilt 1978 · S/N D-10177 N5840KFrogmore V-Tail LLC · Beaufort, SCBuilt 1965 · S/N D-7850 N5840SBergstrom Aircraft Inc · Pasco, WABuilt 1965 · S/N D-7896 N5841KJones David E · Corsicana, TXBuilt 1965 · S/N D-7852 N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842 N5842KSander John B · Knoxville, TNBuilt 1965 · S/N D-7853 N5842TArapaho Air LLC · Walnut Grove, CABuilt 1964 · S/N 185-0742 N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843 N5843MEastern Aero LLC · Gibsonville, NCBuilt 1969 · S/N 310P0143 N58441Tall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N U20602604 N5844SFilips Roger F · Spencer, NEBuilt 1964 · S/N D-7741 N5844YLindsey Charles A · Madison, GABuilt 1980 · S/N TH-1148 N5845SCircle City Balloon Rides LLC · Indianapolis, INBuilt 1964 · S/N D-7739 N58466Aerial Transport LLC · Dover, DEBuilt 1974 · S/N U20602609 N5846KMcclendon Jon L · Kilgore, TXBuilt 1965 · S/N D-7847 N5847SRegistered aircraftBuilt 1965 · S/N D-7742 N5848KCater Benjamin · Fresno, CABuilt 1965 · S/N D-7891 N5849JFowler Jon E · Hallock, MNBuilt 1970 · S/N 18501818 N5849KRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1965 · S/N D-7881 N584BLSale Reported · Greeley, COSale reportedBuilt 1974 · S/N TH-446 N584CDBrothers David M Trustee · Cainsville, MOBuilt 2005 · S/N 1652 N584CKKalitta Charters LLC · Ypsilanti, MIBuilt 1973 · S/N TH-319 N584CLKetcham Francis A · Sausalito, CAS/N TH-1034 N584DFHangar 3 LLC · Milledgeville, GABuilt 1990 · S/N TH-1605 N584DGN584dg LLC · Nashua, NHBuilt 1979 · S/N TH-1042 N584DSRose Michael · Prescott, AZBuilt 1981 · S/N TJ-343 N584DTTiger Flight LLC · Florence, SCBuilt 1995 · S/N TH-1745 N584DWAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2014 · S/N TH-2394 N584HPN305yv LLC · Doral, FLBuilt 1983 · S/N TH-1365 N584JTGoff James T · Sunriver, ORBuilt 1980 · S/N TH-1127 N584MBCenterline Holdings Inc · Camden, DES/N TK-151 N584METwo Spinny Things LLC · Overland Park, KSBuilt 1974 · S/N TH-427 N584MWRela Matthew V · Monroe, NJBuilt 1991 · S/N TH-1615 N584PCHurry Back Air LLC · Knoxville, TNBuilt 2007 · S/N TH-2211 N584RJRocky Mount Rental And Leasing Inc · Rocky Mount, NCBuilt 2014 · S/N TH-2417 N584RMBe5816 LLC · Simi Valley, CABuilt 2016 · S/N TH-2459 N584RUJayhawk 58 Leasing LLC · Wichita, KSBuilt 2007 · S/N TH-2203 N584SMRegistered aircraftBuilt 1973 · S/N TH-412 N584TBSundancer Enterprises LLC · Norman, OKBuilt 1997 · S/N TH-1810 N584WKing Air Ny LLC · Schenectady, NYBuilt 1993 · S/N TH-1699 N58502H E Fly Float LLC · Virginia Beach, VABuilt 1974 · S/N U20602618

Back to AD 86-13-04 R3