Skip to content

Registered aircraft · 3,462

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:2002-23-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:2002-23-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:2002-23-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:2002-23-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:2002-23-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:2002-23-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.

N708U S Department Of The Interior · Boise, IDBuilt 2008 · S/N 100-0007 N708EFDejong Merritt · Newburgh, INS/N 21 N708KAJb Leasing Company LLC · Kenai, AKBuilt 1954 · S/N 59 N708PVPm Leasing Inc · Perris, CABuilt 1976 · S/N 489 N708SAOlivier Seth Nicholas · Baskin, LABuilt 1981 · S/N 31T-8104042 N709EAAerolease LLC · Fargo, NDBuilt 1992 · S/N LJ-1309 N709FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0430 N709KAKenmore Air Harbor LLC · Kenmore, WABuilt 1960 · S/N 410 N70AVQualitair LLC Trustee · MichelstadtBuilt 1991 · S/N 6 N70CULou Dell Aviation LLC · Simpsonville, SCBuilt 1981 · S/N BB-888 N70EAEagle Air Transport · Ottawa, ILS/N 139 N70LTBarren Troy Aviation LLC · Centennial, COBuilt 1999 · S/N 151 N70MNState Of Minnesota · Saint Paul, MNBuilt 1993 · S/N BB-1447 N70RMRem Industries LLC · Farragut, TNBuilt 2024 · S/N 46020013 N70UDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1967 · S/N LM-51 N70VRSkeeterhawk Aero LLC · Sheridan, WYBuilt 2001 · S/N LJ1651 N71Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-6 N710United States Dept Of The Interior · Boise, IDBuilt 2009 · S/N 100-0021 N710FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0431 N710GWGoing To Work Aviation LLC · Wildwood, FLBuilt 1998 · S/N FL-228 N710LAJefferson Davis Parish Mosquito Abatement Dist #1 · Jennings, LABuilt 2010 · S/N 502B-2711 N710LWWerth Lance C · Johnson Lake, NEBuilt 2023 · S/N T660-175 N711DJett Aviation Partners LLC · Bismarck, NDBuilt 1989 · S/N 4622036 N711FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0433 N711PMVinton Aero LLC · Cedar Springs, MIBuilt 2002 · S/N 234 N711SBCashsouth LLC · Georgetown, DEBuilt 2001 · S/N 4697075 N711VNKa350 N711vn LLC · Plano, TXBuilt 1990 · S/N FL-7 N711VVMaynard Aviation LLC · Westfield, MABuilt 1990 · S/N BB-1365 N7125NKsnl Aero LLC · Shawnee, OKBuilt 2015 · S/N 208B5235 N712FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0435 N712FYAddison Automatics Inc · Harmon, ILBuilt 2024 · S/N 46020012 N712GSAt402 LLC · Banquete, TXBuilt 2007 · S/N 402B-1189 N712MKAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1986 · S/N 4608032 N712WCKappen Aviation LLC · Cass City, MIBuilt 2021 · S/N 100-0304 N713FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0438 N713RHFalcon Air LLC · Olive Branch, MSBuilt 1987 · S/N BB-1274 N714WVPeasant Air LLC · Middletown, DEBuilt 2005 · S/N 614 N7155PDynamic Avlease Inc · Bridgewater, VABuilt 1968 · S/N LM-107 N715FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0440 N715GC6ts Holdings LLC · Mineola, TXBuilt 2012 · S/N LJ-2039 N715HETatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1997 · S/N 208B0603 N715JRJasdip Aviation Inc · Seattle, WABuilt 2016 · S/N 100-0178 N715VTnt Operations LLC · Missoula, MTBuilt 1995 · S/N 108 N716BMTraveling Toes LLC · Wilmington, DEBuilt 1993 · S/N FL-103 N716FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0442 N716MMArne Aviation LLC · Suffolk, VAS/N 208B0746 N716TAB P Air LLC · Delhi, LAFirst renewal noticeBuilt 1995 · S/N BB-1509 N717FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0445 N717JGHvl Air · Fresno, CABuilt 1975 · S/N LJ-672 N717LETentacle Corp · Walnut Creek, CABuilt 1988 · S/N 549

Back to AD 2002-23-13