Registered aircraft · 1,287

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-22-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-22-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-22-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-22-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-22-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-22-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.

N630ARAar International Financial Services LLC · Wood Dale, ILBuilt 2009 · S/N 5797 N633SASlate Aircraft Company LLC · Johnstown, PAS/N 7988 N633WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5951 N640GRDodson International Parts Inc · Rantoul, KSS/N 5093 N648CR7107 Associates LLC · Wilmington, DEBuilt 2005 · S/N 5633 N648SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5720 N64JSCelebration Tv America Inc · Houston, TXBuilt 1992 · S/N 5119 N64LELuxury Jet Acquisitions Inc · Newville, ALBuilt 1988 · S/N 5031 N650ADAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2019 · S/N 6135 N650BSBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 6078 N650CFTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2019 · S/N 6136 N650DWGbhp Associates LLC · Saratoga Springs, NYBuilt 2024 · S/N 6208 N650ELBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 6138 N650FBSierra Nevada Company LLC · Sparks, NVBuilt 2025 · S/N 6226 N650FNRegistered aircraftN-number assigned (import), not yet registeredS/N 6241 N650GEFlying High Leasing LLC · Atlanta, GABuilt 2019 · S/N 6132 N650GKGekabi Aviation LLC · The Woodlands, TXBuilt 2016 · S/N 6065 N650GPOcean Acquisition 3 LLC · Denver, COBuilt 2018 · S/N 6124 N650HJLambro Aircraft Management LLC · Hillsboro Beach, FLBuilt 2006 · S/N 5653 N650HNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 6160 N650JRRegistered aircraftBuilt 2016 · S/N 6081 N650LCAgco Corp · Duluth, GABuilt 2017 · S/N 6098 N650LERegistered aircraftN-number assigned (import), not yet registeredS/N 6240 N650RSSchumacher Oil LLC · Whitefish, MTS/N 7779 N650SKPnc Bank Na · Boise, IDBuilt 2017 · S/N 6096 N651AMAirmed International LLC · Birmingham, ALBuilt 2011 · S/N 5883 N651JDA S K Equipment Leasing LLC · Cumming, GABuilt 2012 · S/N 5921 N651LSWestwind Air Holdings Inc · Wilmington, DEBuilt 1999 · S/N 5413 N652AMAirmed International LLC · Birmingham, ALBuilt 2008 · S/N 5756 N652KBAvex Xii LLC · Fort Lauderdale, FLBuilt 1996 · S/N RK-120 N654CMPacific States Industries Inc · Morgan Hill, CABuilt 1987 · S/N 5009 N659BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2001 · S/N 7509 N65PXSpx Enterprises LLC · Charlotte, NCBuilt 2009 · S/N 5804 N65SQMtj Aviation LLC · Mooresville, NCS/N RK-438 N660CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N RK-319 N661WDEncore Jet Management LLC · San Antonio, TXBuilt 1994 · S/N RK-94 N669LAFlash Enterprise LLC · Helena, MTBuilt 1989 · S/N 5050 N671UPJersey Aviation LLC · Stamford, CTBuilt 2005 · S/N RK-415 N673UPWheels Up Partners LLC · New York, NYBuilt 2005 · S/N RK-452 N674DJFalcon 7 LLC · Wilmington, DEBuilt 1999 · S/N RK-232 N675BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 7635 N675UPWheels Up Partners LLC · New York, NYS/N RK-363 N676UPCove Capital Investments LLC · Wilmington, DEBuilt 2008 · S/N RK-570 N677KEJgp Aviation LLC · St Joseph, MOBuilt 1997 · S/N RK-135 N679SASkywest Airlines Inc · St George, UTS/N 7652 N679SJDodson International Parts Inc · Rantoul, KSS/N RK-168 N679WDanforth LLC · Columbus, OHBuilt 2020 · S/N 6158 N67RSLabell Aviation LLC · Spring Hill, FLBuilt 1994 · S/N 5149 N681HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2001 · S/N 5518 N683UFUnifirst Corp · Manchester, NHBuilt 2007 · S/N 5734

Back to AD 2002-22-13