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.

N746FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0498 N747AEAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2019 · S/N LJ-2171 N747FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0238 N747FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0501 N748FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0241 N748FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0503 N749FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0242 N74GCDiamond Bar LLC · Kirkland, WABuilt 1977 · S/N 559 N74GJSkydive Greene County · Xenia, OHBuilt 1961 · S/N BA-559 N74KSR & R Pallet Of Garden City · Garden City, KSBuilt 2000 · S/N FL-299 N74KTEvo81 LLC · Walnut Creek, CABuilt 2022 · S/N EVO-0081 N74RFAir Flair Inc · Maurice, IABuilt 1983 · S/N 425-0153 N75Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-10 N7500SHill Ag-Air LLC · Bancroft, IDS/N 829B N75090Gasper Air Spray Inc · Crookston, MNBuilt 1992 · S/N 831B N7509VRichard Flying Service Inc · Rayne, LABuilt 1991 · S/N 828B N7509YAnderson'S Flying Service Inc · Yuba City, CABuilt 1992 · S/N 830B N750ABNpa Aviation LLC · Lafayette, LABuilt 1991 · S/N 4 N750AYSkydive North West Inc Trustee · Wilmington, DEBuilt 2004 · S/N 107 N750DVT & T Delaware Aviation LLC · Wilmington, DEBuilt 2005 · S/N 112 N750DZBranded X LLC · Springfield, ORBuilt 2004 · S/N 108 N750FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0511 N750GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 113 N750KAN750ka LLC · Wilmington, DEBuilt 1977 · S/N BB224 N750KPAircraft Structures International Corp · Enid, OKBuilt 1997 · S/N 208B0628 N750RCLuke & Payton LLC · Marianna, ARS/N LJ-640 N750SDSkydive Coolidge Inc · Tempe, AZBuilt 2004 · S/N 111 N750SNBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 142 N750SSPacair LLC · Brookline, NHBuilt 2005 · S/N 115 N750TTDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N BB215 N750UPSpecialty Aircraft LLC · Trapper Creek, AKBuilt 2007 · S/N 133 N750VLLiam 750 Inc · Charlevoix, MIBuilt 2012 · S/N 182 N750VXRandigo LLC · Wilmington, DEFirst renewal noticeBuilt 2007 · S/N 0132 N750XLArne Aviation LLC · Suffolk, VABuilt 2004 · S/N 109 N750ZSouthern Airways Pacific LLC · Addison, TXBuilt 2004 · S/N 208B1054 N751BXSouth Seattle College · Seattle, WABuilt 2006 · S/N LIV-582 N751FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0245 N751FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0514 N751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSBuilt 1980 · S/N LJ-887 N751MANorth Summit Leasing LLC · Bellevue, WABuilt 2016 · S/N 100-0184 N751WYMcclain Dean L · Torrington, WYBuilt 1989 · S/N 814B N752FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0247 N752FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0517 N752MMMc Aviation LLC · Fort Lauderdale, FLBuilt 2004 · S/N 4697192 N753BXUtah State University · Logan, UTBuilt 2007 · S/N LIV-585 N753CAMoon Mountain Montana LLC · Missoula, MTBuilt 2000 · S/N 163 N753FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0520 N753GSClaire Aviation Inc · Wilmington, DEBuilt 2011 · S/N LJ-2013 N754FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0526 N755DMMdst Aircraft Leasing LLC · Ripon, WIBuilt 1994 · S/N 101

Back to AD 2002-23-13