Registered aircraft · 2,862

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

N555KTKilo Tango LLC · Birmingham, ALBuilt 1996 · S/N 560-0368 N555PGWagner Air LLC · Kendalia, TXBuilt 1991 · S/N 5600102 N555WLGolf Air Inc · Bloomfield Hills, MIBuilt 1998 · S/N 560-0488 N556BGCitation Investments LLC · Dallas, TXBuilt 1999 · S/N 560-0499 N556HDN50hd LLC · Salt Lake City, UTBuilt 2002 · S/N 321 N556MWN970aj LLC · Evans, COBuilt 2003 · S/N 550-1074 N557HPBlues City Aviation LLC · Germantown, TNBuilt 2008 · S/N 525-0668 N557MMUvalde Land Company LLC · Valdosta, GABuilt 1990 · S/N 5600045 N557MRMrjl LLC · Wilmington, DEBuilt 1996 · S/N 560-0393 N557PGCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 2003 · S/N 560-0557 N558CGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1990 · S/N 5500664 N558WGMom2 Advisors LLC · Wilmington, DEBuilt 2018 · S/N 525-1008 N558WWWestwood Property Management Inc · Aurora, ORBuilt 1992 · S/N 560-0180 N559BMCrockett & Koehler Lc · Layton, UTBuilt 1994 · S/N 560-0259 N559SFSd Aviation LLC · Aberdeen, SDBuilt 1998 · S/N 560-0482 N559WJWanger Jones Helsley Pc · Fresno, CABuilt 2000 · S/N 550-0909 N55BAKarma55ba LLC · Stuart, FLS/N 258356 N55CJN55cj LLC · Modesto, CABuilt 1998 · S/N 525-0298 N55EAShamrock Aviation LLC · Greensboro, NCBuilt 1990 · S/N 560-0055 N55FGWestwind Air LLC · Canton, GABuilt 1979 · S/N 267 N55HSRapid Leasing Inc · Cedar Rapids, IABuilt 1998 · S/N 276 N55JPDakota Aircraft Inc · Pierre, SDBuilt 1998 · S/N 525-0296 N55LBPie High LLC · Atlanta, GABuilt 2000 · S/N 258494 N55LXWoodbine Aviation LLC · Lewes, DES/N 550-0366 N55MWCitation 560 LLC · Oshkosh, WIBuilt 2005 · S/N 560-0688 N55SKSierrakilo LLC Trustee · Fort Lauderdale, FLBuilt 1994 · S/N 525-0063 N55VHCombined Aircraft Ownership LLC · Fargo, NDBuilt 2022 · S/N 525-1120 N55WLLatshaw Sonja M · Vero Beach, FLBuilt 1980 · S/N 550-0140 N55XPAtlas Leasing Partners LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258583 N560AFMegashipp Ventures II LLC · The Woodlands, TXBuilt 1990 · S/N 560-0100 N560AVTeton Leasing LLC · Pocatello, IDBuilt 1995 · S/N 560-0321 N560BCPlatform Energy Aviation LLC · Lubbock, TXBuilt 1990 · S/N 560-0032 N560BJBanu LLC · Las Vegas, NVBuilt 1990 · S/N 560-0058 N560BLKac Md LLC · Fort Mill, SCBuilt 2002 · S/N 560-0633 N560BMBruce Tanski Construction & Development LLC · Halfmoon, NYBuilt 2004 · S/N 560-0668 N560BPCitation V Partners LLC · Las Vegas, NVBuilt 1992 · S/N 560-0172 N560CJettech Holdings LLC · Broomfield, COBuilt 1998 · S/N 560-0461 N560CBAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2004 · S/N 560-0655 N560CCJet Centennial LLC · Greenwood Village, COS/N 560-0064 N560CE5 Star Aviation LLC · Aurora, MOBuilt 2001 · S/N 560-0555 N560CFMax Air Group LLC · Waterford, MIBuilt 1990 · S/N 560-0040 N560CJTrans Exec Air Service Inc · Van Nuys, CABuilt 1990 · S/N 5600086 N560CSPlatinum Faith LLC · Middletown, DEBuilt 2001 · S/N 560-0549 N560CVHw Aviation LLC · Katy, TXBuilt 1989 · S/N 560-0038 N560CXSpudaire LLC · Pasco, WABuilt 2001 · S/N 560-0582 N560CZRosado Aviation Inc · Moosic, PABuilt 1989 · S/N 560-0002 N560DLLandmark Media Enterprises LLC · Norfolk, VAS/N 560-0761 N560EMEjb LLC · Ponce Inlet, FLBuilt 1992 · S/N 5600201 N560EPZero Five Kilo Corporate · Jackson, WYBuilt 2008 · S/N 560-0794 N560FFParrott Air LLC · Florence, SCBuilt 1998 · S/N 560-0477

Back to AD 97-05-03 R1