Skip to content

Registered aircraft · 532

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

N529LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 560-5557 N535BPBum Aviation LLC · Green Bay, WIBuilt 2003 · S/N 560-0646 N536JA560-5166 LLC · Greenfield, INBuilt 2001 · S/N 560-5166 N53STBlue Link LLC · Bay City, WIBuilt 2002 · S/N 560-0624 N53WFAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1999 · S/N 560-5057 N5434KKowalik Raymond J Trustee · Lees Summit, MOBuilt 2003 · S/N 560-5345 N543TATriton Jets LLC · Lexington, KYS/N 560-5331 N543WGAlliance Aviation Group LLC · Wilmington, DES/N 560-5243 N550MLDjp Properties LLC · Selma, CABuilt 2004 · S/N 550-1082 N550RMReal X Jet LLC · Sarasota, FLBuilt 2005 · S/N 550-1099 N550SKAfp Travel LLC · Waco, TXBuilt 2001 · S/N 550-0999 N550VGJ Industries LLC · Lewes, DEBuilt 2001 · S/N 5500994 N551ZD501zd LLC · Palm Coast, FLBuilt 2000 · S/N 550-0903 N552CNRer Plane LLC · San Antonio, TXBuilt 2004 · S/N 560-0674 N552SCPtc Aviation LLC · Northport, ALBuilt 2001 · S/N 560-5144 N554TT & T Enterprises LLC · Santa Clara, CABuilt 2005 · S/N 550-1100 N554VPJl Diversified LLC · Scottsdale, AZBuilt 2001 · S/N 560-0554 N555WZHi Tequity Air Holdings Spv LLC · Melbourne Beach, FLBuilt 2004 · S/N 560-5366 N556LSCharlie Brown Air III LLC · Boca Raton, FLBuilt 2002 · S/N 560-5276 N556WFClearair LLC · Taylorsville, NCBuilt 1999 · S/N 560-5024 N557PGCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 2003 · S/N 560-0557 N55MWCitation 560 LLC · Oshkosh, WIBuilt 2005 · S/N 560-0688 N55VWVariety Wholesalers Inc · Henderson, NCBuilt 2000 · S/N 560-5076 N560ADAir Direct LLC · Powderly, TXBuilt 2002 · S/N 560-5239 N560ARBrook Haven Properties LLC · Camden, DEFirst renewal noticeS/N 560-6026 N560AWAurora Ventures LLC · Saint Paul, MNBuilt 2003 · S/N 560-5351 N560BDDm Petroleum LLC · Sherman, TXBuilt 2002 · S/N 560-5257 N560BERegistered aircraftBuilt 2025 · S/N 560-6503 N560BLKac Md LLC · Fort Mill, SCBuilt 2002 · S/N 560-0633 N560BMBruce Tanski Construction & Development LLC · Halfmoon, NYBuilt 2004 · S/N 560-0668 N560BTG & R Aviation LLC · Louisville, KYBuilt 1999 · S/N 560-5031 N560CBAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2004 · S/N 560-0655 N560CE5 Star Aviation LLC · Aurora, MOBuilt 2001 · S/N 560-0555 N560CGMgl Partners LLC · Saint Louis, MOBuilt 2000 · S/N 560-5121 N560CRVmair Partners Inc · Wilmington, DEBuilt 2002 · S/N 560-5229 N560CXSpudaire LLC · Pasco, WABuilt 2001 · S/N 560-0582 N560DRAj Aero Holdings Inc · Dover, DEBuilt 2000 · S/N 560-5073 N560DXOrchid Island Aviation Inc · Daytona Beach, FLBuilt 2004 · S/N 560-5372 N560EXExelco Aviation LLC · Laredo, TXBuilt 2000 · S/N 560-5074 N560FPEdwards Carl E Jr Trustee · Oklahoma City, OKBuilt 2001 · S/N 560-0566 N560GKG Money LLC · Delavan, WIBuilt 2001 · S/N 560-5138 N560HKa N22cr LLC · Lewes, DEBuilt 2001 · S/N 560-0576 N560HMG Money LLC · Delavan, WIBuilt 2006 · S/N 560-0699 N560HN5437 Holdings LLC · Houston, TXBuilt 1998 · S/N 560-5015 N560HXExcelevators LLC · Farmingdale, NYBuilt 2000 · S/N 560-5139 N560JCFive Sixty Group LLC · Sheridan, WYFirst renewal noticeBuilt 2001 · S/N 560-5214 N560JW3640 Aviation LLC · Mandeville, LABuilt 2001 · S/N 560-0560 N560KCN560kc LLC · Omaha, NEBuilt 2000 · S/N 560-5102 N560KSAlva Acquisitions LLC · Arkadelphia, ARBuilt 2001 · S/N 560-5151 N560LALee Aerospace Inc · Wichita, KSBuilt 2003 · S/N 560-5334

Back to AD 2003-03-21