Skip to content

Registered aircraft · 534

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.

N655TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5251 N656CNCorporate Flight Management Incdba · Smyrna, TNBuilt 2005 · S/N 560-5551 N657CNCorporate Flight Management Inc · Smyrna, TNBuilt 2005 · S/N 560-5572 N664CEPride Aviation Support LLC · Exeter, PABuilt 2004 · S/N 560-0664 N668TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5268 N670KF2012 Leasing Inc · Saint Paul, MNBuilt 2002 · S/N 560-5306 N670MWDg Financial Consulting Inc · Longview, TXBuilt 2004 · S/N 560-5511 N675SSStructural Steel Services Inc · Meridian, MSBuilt 2006 · S/N 550-1123 N676TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 560-5367 N681JZDanco Builders · Arcata, CABuilt 2004 · S/N 560-0681 N682DGDpr Group LLC · Marshall, TXBuilt 2004 · S/N 560-0673 N690MJNorth South Aviation LLC · Sheridan, WYBuilt 2000 · S/N 560-5133 N690TXKancolo Aero LLC · Wichita, KSBuilt 2002 · S/N 560-5290 N691TWSage Holdings LLC · Woodward, OKBuilt 2005 · S/N 560-0691 N692TXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 560-5293 N695AKAlascom Inc · Anchorage, AKBuilt 2005 · S/N 560-0695 N697SDMia Jets Acquisitions LLC · Miami, FLBuilt 2001 · S/N 560-5197 N6TRJmr Aviation LLC · Midland, TXBuilt 2001 · S/N 560-0573 N700NKBoring Plane LLC · Columbia, MOBuilt 2006 · S/N 560-0700 N703PPink Ribbon Aviation LLC · Wilmington, DEBuilt 2003 · S/N 560-5317 N705SGUnion Of Operating Engineers · Pasadena, CABuilt 2001 · S/N 560-5142 N706RRRr604 LLC · Charlotte, NCS/N 560-5247 N706WLScheels All Sports Inc · Fargo, NDBuilt 2000 · S/N 560-5036 N707WWgi Leasing Inc · Vancouver, WABuilt 2001 · S/N 560-0556 N708MBas Part Sales LLC · Greeley, COBuilt 2001 · S/N 560-5194 N70BCSale Reported · Wilmington, DESale reportedBuilt 2002 · S/N 560-5279 N70ECKb Air LLC · Mason, OHBuilt 2002 · S/N 560-0609 N70THAlliance Aviation Group LLC · Wilmington, DEBuilt 1998 · S/N 560-5007 N711FPF A Peinado LLC · Frisco, TXBuilt 2005 · S/N 560-5565 N711XSSteiner Gp LLC · Weatherford, TXBuilt 2004 · S/N 560-0678 N712BDBravo Delta Holdings LLC · Austin, TXBuilt 2002 · S/N 550-1025 N712PVTacocat LLC · Omaha, NEBuilt 2005 · S/N 560-5556 N713TXZeplane LLC · Miami, FLBuilt 2000 · S/N 560-5063 N716LDDorf Air Leasing LLC · Saint Louis, MOBuilt 2002 · S/N 560-5255 N719TTZorair LLC · Houston, TXBuilt 2004 · S/N 560-5516 N719WRBroadband Of Indiana LLC · Owensboro, KYBuilt 1999 · S/N 550-0897 N71HCSoar20 LLC · Holmes, FLBuilt 2000 · S/N 560-5084 N721NBOneonta Trading Corp · Wenatchee, WABuilt 2004 · S/N 560-0659 N724GTCoral One LLC · Orlando, FLS/N 560-5564 N727PJBlack Hat Ventures Pp LLC · Naples, FLBuilt 2001 · S/N 560-5184 N72SGAero Air Charter Holding LLC · Pensacola, FLBuilt 2004 · S/N 560-5508 N748WRt Air II LLC · Little Rock, ARBuilt 2004 · S/N 560-5531 N749XLMitchco Air LLC · Louisville, KYBuilt 2005 · S/N 560-5577 N74GRRobinson George A IV · Houston, TXBuilt 2006 · S/N 560-0704 N750BABklavi LLC · New Richmond, WIBuilt 1998 · S/N 560-5002 N75XL5437 Holdings LLC · Houston, TXBuilt 2000 · S/N 560-5079 N760EDLimnes Aviation LLC · Hillsboro, ORBuilt 2001 · S/N 560-5201 N766CBNals Apartment Homes LLC · Ogden, UTBuilt 2003 · S/N 560-5341 N767BSBrewer Air LLC · Orwigsburg, PABuilt 2001 · S/N 560-5191 N769BBJ2s LLC · Benton, ARBuilt 2002 · S/N 550-1042

Back to AD 2003-03-21